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.
Problems that run through this table