Previous Next JavaScript must be enabled to correctly display this content

CSE_GENEALOGY_COMPOSITION_V

Details

Schema: FUSION
Object owner: CSE
Object type: VIEW

Columns

Name

ROOT_GEN_OBJECT_ID

ROOT_ITEM_ID

ROOT_ORGANIZATION_ID

ROOT_LOT_NUMBER

ROOT_SERIAL_NUMBER

ROOT_ORIG_DATE

ROOT_ORIG_QUANTITY

ROOT_ORIG_DOC_TYPE

ROOT_ORIG_DOC_NUMBER

RELATIONSHIP_TYPE_CODE

PARENT_GEN_OBJECT_ID

PARENT_ITEM_ID

PARENT_ORGANIZATION_ID

PARENT_LOT_NUMBER

PARENT_SERIAL_NUMBER

PARENT_ORIG_DATE

PARENT_ORIG_QUANTITY

PARENT_ORIG_DOC_TYPE

PARENT_ORIG_DOC_NUMBER

CHILD_LEVEL

CHILD_GEN_OBJECT_ID

CHILD_ITEM_ID

CHILD_ORGANIZATION_ID

CHILD_LOT_NUMBER

CHILD_SERIAL_NUMBER

CHILD_ORIG_DATE

CHILD_ORIG_QUANTITY

CHILD_ORIG_DOC_TYPE

CHILD_ORIG_DOC_NUMBER

Query

SQL_Statement

SELECT root_gen_object_id,

root_item_id,

root_organization_id,

root_lot_number,

root_serial_number,

root_orig_date ,

root_orig_quantity,

root_orig_doc_type,

root_orig_doc_number,

relationship_type_code,

parent_gen_object_id,

parent_item_id,

parent_organization_id,

parent_lot_number,

parent_serial_number,

parent_orig_date,

parent_orig_quantity,

parent_orig_doc_type,

parent_orig_doc_number,

child_level,

child_gen_object_id,

child_item_id,

child_organization_id,

child_lot_number,

child_serial_number,

child_orig_date,

child_orig_quantity,

child_orig_doc_type,

child_orig_doc_number

FROM cse_genealogy_composition