Product: | CSP - Spares Management |
---|---|
Description: | Supply and demand summary created by batchprogram |
Implementation/DBA Data: | APPS.CSP_CURR_SUP_DEM_SUMS_V2 |
SELECT CPP.NODE_NAME
, CPP.PLANNING_PARAMETERS_ID
, CPP.ORGANIZATION_ID
, CPP.SECONDARY_INVENTORY
, NVL(CPP.PARENT_NODE_ID
, -1) PARENT_NODE_ID
, MSIV.INVENTORY_ITEM_ID
, MSIV.CONCATENATED_SEGMENTS
, MSIV.DESCRIPTION
, MSIV.PRIMARY_UOM_CODE
, CCSDS.ONHAND_GOOD
, CCSDS.ONHAND_BAD
, CCSDS.INTRANSIT_MOVE_ORDERS
, CCSDS.OPEN_PURCHASE_ORDERS
, CCSDS.OPEN_SALES_ORDERS
, CCSDS.OPEN_WORK_ORDERS
, CCSDS.OPEN_REQUISITIONS
, CCSDS.OPEN_MOVE_ORDERS_IN
, CCSDS.OPEN_MOVE_ORDERS_OUT
, CCSDS.OPEN_INTERORG_TRANSF_IN
, CCSDS.OPEN_INTERORG_TRANSF_OUT
, CCSDS.OPEN_MOVE_ORDERS_IN+CCSDS.OPEN_INTERORG_TRANSF_IN TRANSFER_IN
, CCSDS.OPEN_MOVE_ORDERS_OUT+CCSDS.OPEN_INTERORG_TRANSF_OUT TRANSFER_OUT
FROM CSP_CURR_SUP_DEM_SUMS CCSDS
, MTL_SYSTEM_ITEMS_VL MSIV
, CSP_PLANNING_PARAMETERS CPP
WHERE MSIV.ORGANIZATION_ID = CCSDS.ORGANIZATION_ID
AND MSIV.INVENTORY_ITEM_ID = CCSDS.INVENTORY_ITEM_ID
AND CPP.PLANNING_PARAMETERS_ID = CCSDS.PLANNING_PARAMETERS_ID