View: CSP_RESOURCE_DEFAULT_INV_LOC_V

Product:	CSP - Spares Management
Description:	Get the default Part In or Part Out Subinventories assigned to a resource in a loop
Implementation/DBA Data:	APPS.CSP_RESOURCE_DEFAULT_INV_LOC_V

View Text

SELECT CILA.RESOURCE_ID
, CILA.RESOURCE_TYPE
, CILA.SUBINVENTORY_CODE
, CILA.DEFAULT_CODE
, CSI.PARTS_LOOP_ID
, CILA.ORGANIZATION_ID
, CILA.EFFECTIVE_DATE_START
, CILA.EFFECTIVE_DATE_END FROM CSP_INV_LOC_ASSIGNMENTS CILA
, CSP_SEC_INVENTORIES CSI
WHERE CSI.SECONDARY_INVENTORY_NAME = CILA.SUBINVENTORY_CODE
AND CSI.ORGANIZATION_ID = CILA.ORGANIZATION_ID
AND CILA.DEFAULT_CODE IN ('IN'
, 'OUT')

Columns