Oracle Fusion · Data dictionary
CSE_GENEALOGY_WHERE_USED_V
SharedUsed in 1 subject areas21 reporting columns
denormalized view.
Primary key: not yet catalogued for CSE_GENEALOGY_WHERE_USED_V — reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CHILD_GEN_OBJECT_ID | ● | Identifier for the child gen object. | |
| CHILD_ITEM_ID | ● | Identifier for the child item. | |
| CHILD_LOT_NUMBER | ● | Child lot number. | |
| CHILD_ORGANIZATION_ID | ● | Identifier for the child organization. | |
| CHILD_ORIG_DOC_NUMBER | ● | Child orig doc number. | |
| CHILD_ORIG_DOC_TYPE | ● | Type of child orig doc. | |
| CHILD_ORIG_QUANTITY | ● | Child orig quantity. | |
| CHILD_SERIAL_NUMBER | ● | Child serial number. | |
| LEAF_CHILD_GEN_OBJECT_ID | ● | Identifier for the leaf child gen object. | |
| LEAF_CHILD_ORIG_DOC_NUMBER | ● | Leaf child orig doc number. | |
| LEAF_CHILD_ORIG_DOC_TYPE | ● | Type of leaf child orig doc. | |
| LEAF_CHILD_ORIG_QUANTITY | ● | Leaf child orig quantity. | |
| PARENT_GEN_OBJECT_ID | ● | Identifier for the parent gen object. | |
| PARENT_ITEM_ID | ● | Identifier for the parent item. | |
| PARENT_LEVEL | ● | Parent level. | |
| PARENT_LOT_NUMBER | ● | Parent lot number. | |
| PARENT_ORGANIZATION_ID | ● | Identifier for the parent organization. | |
| PARENT_ORIG_DOC_NUMBER | ● | Parent orig doc number. | |
| PARENT_ORIG_DOC_TYPE | ● | Type of parent orig doc. | |
| PARENT_ORIG_QUANTITY | ● | Parent orig quantity. | |
| PARENT_SERIAL_NUMBER | ● | Parent serial number. |
Used by reports
No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.
- —
Where this surfaces in OTBI
The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.
Need the extract + dbt staging for CSE_GENEALOGY_WHERE_USED_V?
We ship parameterized SQL, BICC config, and dbt models you own.