View: CSP_AVAILABLE_PARTS_IN_LOOP_V

Product:	CSP - Spares Management
Description:	Checks availability of part in a given loop and gives a list of all the subinventories
Implementation/DBA Data:	APPS.CSP_AVAILABLE_PARTS_IN_LOOP_V

View Text

SELECT CPLB.PARTS_LOOP_ID
, CPLB.ORGANIZATION_ID
, CSI.SECONDARY_INVENTORY_NAME
, CSI.CONDITION_TYPE
, CSP_VALIDATE_PUB.GET_AVAIL_QTY( CPLB.ORGANIZATION_ID
, CSI.SECONDARY_INVENTORY_NAME
, NULL
, MOSV.INVENTORY_ITEM_ID)
, MOSV.INVENTORY_ITEM_ID
, MOSV.REVISION FROM MTL_ONHAND_SUB_V MOSV
, CSP_PARTS_LOOPS_B CPLB
, CSP_SEC_INVENTORIES CSI
WHERE MOSV.ORGANIZATION_ID = CPLB.ORGANIZATION_ID AND CSI.PARTS_LOOP_ID = CPLB.PARTS_LOOP_ID AND CSI.ORGANIZATION_ID = CPLB.ORGANIZATION_ID AND CSI.SECONDARY_INVENTORY_NAME = MOSV.SUBINVENTORY_CODE

Columns