Oracle Fusion · Data dictionary
CSE_GENEALOGY_COMPOSITION_V
SharedUsed in 1 subject areas17 reporting columns
denormalized view.
Primary key: not yet catalogued for CSE_GENEALOGY_COMPOSITION_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_LEVEL | ● | Child level. | |
| 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. | |
| PARENT_GEN_OBJECT_ID | ● | Identifier for the parent gen object. | |
| PARENT_ORIG_DOC_NUMBER | ● | Parent orig doc number. | |
| PARENT_ORIG_DOC_TYPE | ● | Type of parent orig doc. | |
| PARENT_ORIG_QUANTITY | ● | Parent orig quantity. | |
| ROOT_GEN_OBJECT_ID | ● | Identifier for the root gen object. | |
| ROOT_ORIG_DOC_NUMBER | ● | Root orig doc number. | |
| ROOT_ORIG_DOC_TYPE | ● | Type of root orig doc. | |
| ROOT_ORIG_QUANTITY | ● | Root orig quantity. |
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_COMPOSITION_V?
We ship parameterized SQL, BICC config, and dbt models you own.