View: CSP_CURR_SUP_DEM_SUMS_V

Product:	CSP - Spares Management
Description:	Supply and demand summary created by batchprogram
Implementation/DBA Data:	APPS.CSP_CURR_SUP_DEM_SUMS_V

View Text

SELECT CPP.PLANNING_PARAMETERS_ID
, TO_NUMBER( DECODE(CSD.PARTS_LOOP_ID
, NULL
, DECODE(CSD.SUBINVENTORY_CODE
, NULL
, NULL
, CSD.ORGANIZATION_ID)
, CSD.ORGANIZATION_ID))
, DECODE(CSD.PARTS_LOOP_ID
, NULL
, DECODE(CSD.SUBINVENTORY_CODE
, NULL
, NULL
, OOD.ORGANIZATION_CODE)
, OOD.ORGANIZATION_CODE)
, CSD.SUPPLY_DEMAND_ID
, CSD.INVENTORY_ITEM_ID
, MSIV.CONCATENATED_SEGMENTS
, MSIV.DESCRIPTION
, CSD.PARTS_LOOP_ID
, CSD.HIERARCHY_NODE_ID
, DECODE(CSD.SUBINVENTORY_CODE
, NULL
, CRH.PARENT_NODE_ID
, CSD.HIERARCHY_NODE_ID)
, CSD.CREATED_BY
, CSD.CREATION_DATE
, CSD.LAST_UPDATE_DATE
, CSD.LAST_UPDATE_LOGIN
, CSD.LAST_UPDATED_BY
, MSIV.PRIMARY_UOM_CODE
, DECODE(CSD.SUBINVENTORY_CODE
, NULL
, CRH.NODE_NAME
, CSD.SUBINVENTORY_CODE)
, DECODE(CSD.SUBINVENTORY_CODE
, NULL
, 'R'
, 'S ')
, CSI.SECONDARY_INVENTORY_ID
, CSD.ONHAND_BAD
, CSD.ONHAND_GOOD
, CSD.INTRANSIT_MOVE_ORDERS
, CSD.OPEN_PURCHASE_ORDERS
, CSD.OPEN_SALES_ORDERS
, CSD.OPEN_WORK_ORDERS
, CSD.OPEN_REQUISITIONS
, CSD.OPEN_MOVE_ORDERS_IN
, CSD.OPEN_MOVE_ORDERS_OUT
, CSD.OPEN_INTERORG_TRANSF_IN
, CSD.OPEN_INTERORG_TRANSF_OUT
, CSD.OPEN_MOVE_ORDERS_IN+CSD.OPEN_INTERORG_TRANSF_IN
, CSD.OPEN_MOVE_ORDERS_OUT+CSD.OPEN_INTERORG_TRANSF_OUT
, CSD.ATTRIBUTE_CATEGORY
, CSD.ATTRIBUTE1
, CSD.ATTRIBUTE2
, CSD.ATTRIBUTE3
, CSD.ATTRIBUTE4
, CSD.ATTRIBUTE5
, CSD.ATTRIBUTE6
, CSD.ATTRIBUTE7
, CSD.ATTRIBUTE8
, CSD.ATTRIBUTE9
, CSD.ATTRIBUTE10
, CSD.ATTRIBUTE11
, CSD.ATTRIBUTE12
, CSD.ATTRIBUTE13
, CSD.ATTRIBUTE14
, CSD.ATTRIBUTE15
FROM CSP_CURR_SUP_DEM_SUMS CSD
, MTL_SYSTEM_ITEMS_VL MSIV
, CSP_SEC_INVENTORIES CSI
, ORG_ORGANIZATION_DEFINITIONS OOD
, CSP_REP_HIERARCHIES CRH
, CSP_PLANNING_PARAMETERS CPP
WHERE MSIV.ORGANIZATION_ID=CSD.ORGANIZATION_ID
AND MSIV.INVENTORY_ITEM_ID=CSD.INVENTORY_ITEM_ID
AND CSD.ORGANIZATION_ID =CSI.ORGANIZATION_ID (+)
AND CSD.SUBINVENTORY_CODE= CSI.SECONDARY_INVENTORY_NAME(+)
AND CSD.PARTS_LOOP_ID =CSI.PARTS_LOOP_ID (+)
AND CSD.ORGANIZATION_ID=OOD.ORGANIZATION_ID
AND CSD.HIERARCHY_NODE_ID = CRH.HIERARCHY_NODE_ID (+)
AND CPP.PLANNING_PARAMETERS_ID(+) = CSD.PLANNING_PARAMETERS_ID

Columns