View: CSP_RESOURCE_INV_LOC_V

Product:	CSP - Spares Management
Description:	View all move orders and their statuses for a given Service Request and Task Id
Implementation/DBA Data:	APPS.CSP_RESOURCE_INV_LOC_V

View Text

SELECT CILA.RESOURCE_ID
, CILA.RESOURCE_TYPE
, CILA.SUBINVENTORY_CODE
, CSI.CONDITION_TYPE
, CILA.ORGANIZATION_ID
, CILA.EFFECTIVE_DATE_START
, CILA.EFFECTIVE_DATE_END FROM CSP_INV_LOC_ASSIGNMENTS CILA
, CSP_SEC_INVENTORIES CSI
WHERE CSI.ORGANIZATION_ID = CILA.ORGANIZATION_ID
AND CSI.SECONDARY_INVENTORY_NAME = CILA.SUBINVENTORY_CODE AND CSI.CONDITION_TYPE IN ('G'
, 'B')

Columns