VIEW: APPS.CSP_SUP_DEM_RH_V

Source

View Text - Preformatted

SELECT csdrm.inventory_item_id, msibk.concatenated_segments, msibk.description, csdrm.hierarchy_node_id, csdrm.node_name,csdrm.parent_node_id, msibk.primary_uom_code, csdrm.onhand_bad, csdrm.onhand_good, csdrm.intransit_move_orders, csdrm.purchase_orders, csdrm.sales_orders, csdrm.work_orders, csdrm.requisitions, csdrm.move_orders_in, csdrm.move_orders_out, csdrm.interorg_transf_in, csdrm.interorg_transf_out, csdrm.move_orders_in+csdrm.interorg_transf_in transfer_in, csdrm.move_orders_out+csdrm.interorg_transf_out transfer_out ,am.creation_date from csp_sup_dem_rhs csdrm, mtl_system_items_b_kfv msibk, (select sysdate creation_date from dual) am where csdrm.inventory_item_id = msibk.inventory_item_id and csdrm.organization_id = msibk.organization_id union all select csdsm.inventory_item_id, msibk.concatenated_segments,msibk.description,to_number(null),mp.organization_code||'.'||csdsm.subinventory_code,csdsm.hierarchy_node_id, msibk.primary_uom_code, csdsm.onhand_bad, csdsm.onhand_good, csdsm.intransit_move_orders, csdsm.purchase_orders, csdsm.sales_orders, csdsm.work_orders, csdsm.requisitions, csdsm.move_orders_in, csdsm.move_orders_out, csdsm.interorg_transf_in, csdsm.interorg_transf_out, csdsm.move_orders_in+csdsm.interorg_transf_in transfer_in, csdsm.move_orders_out+csdsm.interorg_transf_out transfer_out ,am.creation_date from csp_sup_dem_subs csdsm, mtl_system_items_b_kfv msibk, mtl_parameters mp, (select sysdate creation_date from dual) am where hierarchy_node_id > 0 and csdsm.inventory_item_id = msibk.inventory_item_id and csdsm.organization_id = msibk.organization_id and csdsm.organization_id = mp.organization_id

View Text - HTML Formatted

SELECT CSDRM.INVENTORY_ITEM_ID
, MSIBK.CONCATENATED_SEGMENTS
, MSIBK.DESCRIPTION
, CSDRM.HIERARCHY_NODE_ID
, CSDRM.NODE_NAME
, CSDRM.PARENT_NODE_ID
, MSIBK.PRIMARY_UOM_CODE
, CSDRM.ONHAND_BAD
, CSDRM.ONHAND_GOOD
, CSDRM.INTRANSIT_MOVE_ORDERS
, CSDRM.PURCHASE_ORDERS
, CSDRM.SALES_ORDERS
, CSDRM.WORK_ORDERS
, CSDRM.REQUISITIONS
, CSDRM.MOVE_ORDERS_IN
, CSDRM.MOVE_ORDERS_OUT
, CSDRM.INTERORG_TRANSF_IN
, CSDRM.INTERORG_TRANSF_OUT
, CSDRM.MOVE_ORDERS_IN+CSDRM.INTERORG_TRANSF_IN TRANSFER_IN
, CSDRM.MOVE_ORDERS_OUT+CSDRM.INTERORG_TRANSF_OUT TRANSFER_OUT
, AM.CREATION_DATE
FROM CSP_SUP_DEM_RHS CSDRM
, MTL_SYSTEM_ITEMS_B_KFV MSIBK
, (SELECT SYSDATE CREATION_DATE
FROM DUAL) AM
WHERE CSDRM.INVENTORY_ITEM_ID = MSIBK.INVENTORY_ITEM_ID
AND CSDRM.ORGANIZATION_ID = MSIBK.ORGANIZATION_ID UNION ALL SELECT CSDSM.INVENTORY_ITEM_ID
, MSIBK.CONCATENATED_SEGMENTS
, MSIBK.DESCRIPTION
, TO_NUMBER(NULL)
, MP.ORGANIZATION_CODE||'.'||CSDSM.SUBINVENTORY_CODE
, CSDSM.HIERARCHY_NODE_ID
, MSIBK.PRIMARY_UOM_CODE
, CSDSM.ONHAND_BAD
, CSDSM.ONHAND_GOOD
, CSDSM.INTRANSIT_MOVE_ORDERS
, CSDSM.PURCHASE_ORDERS
, CSDSM.SALES_ORDERS
, CSDSM.WORK_ORDERS
, CSDSM.REQUISITIONS
, CSDSM.MOVE_ORDERS_IN
, CSDSM.MOVE_ORDERS_OUT
, CSDSM.INTERORG_TRANSF_IN
, CSDSM.INTERORG_TRANSF_OUT
, CSDSM.MOVE_ORDERS_IN+CSDSM.INTERORG_TRANSF_IN TRANSFER_IN
, CSDSM.MOVE_ORDERS_OUT+CSDSM.INTERORG_TRANSF_OUT TRANSFER_OUT
, AM.CREATION_DATE
FROM CSP_SUP_DEM_SUBS CSDSM
, MTL_SYSTEM_ITEMS_B_KFV MSIBK
, MTL_PARAMETERS MP
, (SELECT SYSDATE CREATION_DATE
FROM DUAL) AM
WHERE HIERARCHY_NODE_ID > 0
AND CSDSM.INVENTORY_ITEM_ID = MSIBK.INVENTORY_ITEM_ID
AND CSDSM.ORGANIZATION_ID = MSIBK.ORGANIZATION_ID
AND CSDSM.ORGANIZATION_ID = MP.ORGANIZATION_ID