CTO_SALES_V

Details

• Schema: FUSION

• Object owner: CTO

• Object type: VIEW

Columns

Name
ROOT_HEADER_ID BASE_CONFIG_ITEM_ID CONFIG_ITEM_ID BASE_MODEL_ID PARENT_INVENTORY_ITEM_ID CONFIG_BASE_MODEL_ID OPTION_CLASS_ID INVENTORY_ITEM_ID HEADER_ID LINE_ID PARENT_LINE_ID LINKED_ATO_LINE_ID SUB_ITEM_TYPE UNIT_QTY UNIT_UOM CREATION_DATE ITEM_HIERARCHY MATCH_QTY PARENT_ITEM_PATH

Query

SQL_Statement

select ROOT_HEADER_ID, Base_Config_Item_Id, Config_Item_Id, Base_Model_Id, Parent_Inventory_Item_Id, Config_Base_Model_Id, Option_Class_Id, Inventory_Item_id, Header_Id, Line_Id, Parent_Line_Id, Linked_ATO_Line_Id, Sub_Item_Type,/*DECODE(PARENT_SUB_ITEM_TYPE,2,UNIT_QTY/PARENT_MATCH_QTY,NVL(UNIT_QTY,1))*/ UNIT_QTY,Unit_Uom, Creation_Date,ITEM_HIERARCHY,MATCH_QTY,PARENT_ITEM_PATH from ( SELECT ROOT_HEADER_ID, Base_Config_Item_Id, Config_Item_Id, Base_Model_Id, Parent_Inventory_Item_Id, Config_Base_Model_Id, Option_Class_Id, Inventory_Item_id, MT.Header_Id, Line_Id, Parent_Line_Id, Linked_ATO_Line_Id, Sub_Item_Type,/*(select round(exp(sum(ln(DECODE(SUB_ITEM_TYPE,1,ATO_QTY,unit_qty)))),4) from fusion.cto_match_lines l start with l.line_id = MT.line_id connect by LINE_ID= prior PARENT_LINE_ID and prior root_header_id=root_header_id)*/ DECODE(SUB_ITEM_TYPE,1,ATO_QTY,ATO_QTY*UNIT_QTY) UNIT_QTY ,PARENT_SUB_ITEM_TYPE,PARENT_MATCH_QTY, Unit_Uom, Creation_Date, REPLACE(Item_Hierarchy, '//', '/') Item_Hierarchy, Unit_Qty Match_Qty, DECODE(parent_item_path, NULL, NULL, ' '||parent_item_path) parent_item_path FROM cto_match_v MT WHERE MT.LINKED_ATO_LINE_ID IS NULL ) SV