CSE_AS_SOLD_STRUCTURES

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

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_sold_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

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_sold_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