CSE_GENEALOGY_WHERE_USED_V

Details

• Schema: FUSION

• Object owner: CSE

• Object type: VIEW

Columns

Name

LEAF_CHILD_GEN_OBJECT_ID LEAF_CHILD_ITEM_ID LEAF_CHILD_ORGANIZATION_ID LEAF_CHILD_LOT_NUMBER LEAF_CHILD_SERIAL_NUMBER LEAF_CHILD_ORIG_DATE LEAF_CHILD_ORIG_QUANTITY LEAF_CHILD_ORIG_DOC_TYPE LEAF_CHILD_ORIG_DOC_NUMBER RELATIONSHIP_TYPE_CODE 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 PARENT_LEVEL 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

Query

SQL_Statement

SELECT leaf_child_gen_object_id, leaf_child_item_id, leaf_child_organization_id, leaf_child_lot_number, leaf_child_serial_number, leaf_child_orig_date, leaf_child_orig_quantity, leaf_child_orig_doc_type, leaf_child_orig_doc_number, relationship_type_code, 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, parent_level, 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 FROM cse_genealogy_where_used