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