CSE_AS_BUILT_STRUCTURES_V
Details
-
Schema: FUSION
-
Object owner: CSE
-
Object type: VIEW
Columns
Name |
---|
ROOT_ASSET_ID ROOT_ASSET_NUMBER PARENT_ASSET_ID PARENT_ASSET_NUMBER CHILD_ASSET_ID CHILD_LEVEL CHILD_LPAD_CHARS CHILD_ASSET_NUMBER LEAF_NODE RELATIONSHIP_TYPE_CODE ACTIVE_START_DATE ACTIVE_END_DATE ROOT_ASSET_ITEM_ID ROOT_ASSET_ITEM_ORG_ID ROOT_ASSET_LOT_NUMBER ROOT_ASSET_SERIAL_NUMBER ROOT_ASSET_SO_NUMBER ROOT_ASSET_SO_ID ROOT_ASSET_SO_LINE_NUMBER ROOT_ASSET_SO_LINE_ID ROOT_ASSET_LOGICAL_FLAG PARENT_ASSET_ITEM_ID PARENT_ASSET_ITEM_ORG_ID PARENT_ASSET_LOT_NUMBER PARENT_ASSET_SERIAL_NUMBER PARENT_ASSET_SO_NUMBER PARENT_ASSET_SO_ID PARENT_ASSET_SO_LINE_NUMBER PARENT_ASSET_SO_LINE_ID PARENT_ASSET_LOGICAL_FLAG CHILD_ASSET_ITEM_ID CHILD_ASSET_ITEM_ORG_ID CHILD_ASSET_LOT_NUMBER CHILD_ASSET_SERIAL_NUMBER CHILD_ASSET_SO_NUMBER CHILD_ASSET_SO_ID CHILD_ASSET_SO_LINE_NUMBER CHILD_ASSET_SO_LINE_ID |
Query
SQL_Statement |
---|
select rltns.root_asset_id root_asset_id, root_asset.asset_number root_asset_number, rltns.parent_asset_id parent_asset_id, parent_asset.asset_number parent_asset_number, rltns.child_asset_id child_asset_id, child_level child_level, child_lpad_chars child_lpad_chars, child_asset.asset_number child_asset_number, rltns.leaf_node leaf_node, rltns.relationship_type_code relationship_type_code, rltns.active_start_date active_start_date, rltns.active_end_date active_end_date, root_asset.item_id root_asset_item_id, root_asset.item_organization_id root_asset_item_org_id, root_asset.lot_number root_asset_lot_number, root_asset.serial_number root_asset_serial_number, root_asset.sales_order_number root_asset_so_number, root_asset.sales_order_id root_asset_so_id, root_asset.sales_order_line_number root_asset_so_line_number, root_asset.sales_order_line_id root_asset_so_line_id, root_asset.logical_flag root_asset_logical_flag, parent_asset.item_id parent_asset_item_id, parent_asset.item_organization_id parent_asset_item_org_id, parent_asset.lot_number parent_asset_lot_number, parent_asset.serial_number parent_asset_serial_number, parent_asset.sales_order_number parent_asset_so_number, parent_asset.sales_order_id parent_asset_so_id, parent_asset.sales_order_line_number parent_asset_so_line_number, parent_asset.sales_order_line_id parent_asset_so_line_id, parent_asset.logical_flag parent_asset_logical_flag, child_asset.item_id child_asset_item_id, child_asset.item_organization_id child_asset_item_org_id, child_asset.lot_number child_asset_lot_number, child_asset.serial_number child_asset_serial_number, child_asset.sales_order_number child_asset_so_number, child_asset.sales_order_id child_asset_so_id, child_asset.sales_order_line_number child_asset_so_line_number, child_asset.sales_order_line_id child_asset_so_line_id from cse_as_built_relations_v rltns, cse_assets_b root_asset, cse_assets_b parent_asset, cse_assets_b child_asset where root_asset.asset_id = rltns.root_asset_id and parent_asset.asset_id = rltns.parent_asset_id and child_asset.asset_id = rltns.child_asset_id |