View: CSP_RS_SUBINVENTORIES_V

Product:	CSP - Spares Management
Description:	Resource subinventory assignments view
Implementation/DBA Data:	APPS.CSP_RS_SUBINVENTORIES_V

View Text

SELECT I.CSP_INV_LOC_ASSIGNMENT_ID
, I.CREATED_BY
, I.CREATION_DATE
, I.LAST_UPDATED_BY
, I.LAST_UPDATE_DATE
, I.LAST_UPDATE_LOGIN
, I.RESOURCE_TYPE
, I.RESOURCE_ID
, CSP_PICK_UTILS.GET_OBJECT_NAME(I.RESOURCE_TYPE
, I.RESOURCE_ID)
, I.ORGANIZATION_ID
, O.ORGANIZATION_CODE
, I.SUBINVENTORY_CODE
, S.SECONDARY_INVENTORY_ID
, S.LOCATION_ID
, I.LOCATOR_ID
, S.CONDITION_TYPE
, CT.MEANING CONDITION_TYPE_MEANING
, DECODE(I.DEFAULT_CODE
, NULL
, 'N'
, 'Y')
, I.DEFAULT_CODE
, DC.MEANING DEFAULT_CODE_MEANING
, I.EFFECTIVE_DATE_START
, I.EFFECTIVE_DATE_END
, DECODE(I.RESOURCE_ID
, S.OWNER_RESOURCE_ID
, DECODE(I.RESOURCE_TYPE
, S.OWNER_RESOURCE_TYPE
, 'Y'
, 'N')
, 'N') OWNER_FLAG
, S.OWNER_RESOURCE_TYPE
, S.OWNER_RESOURCE_ID
, CSP_PICK_UTILS.GET_OBJECT_NAME(S.OWNER_RESOURCE_TYPE
, S.OWNER_RESOURCE_ID)
, S.RETURN_ORGANIZATION_ID
, RO.ORGANIZATION_CODE RETURN_ORGANIZATION_CODE
, S.RETURN_SUBINVENTORY_NAME
, RS.CONDITION_TYPE
, RCT.MEANING
FROM CSP_INV_LOC_ASSIGNMENTS I
, CSP_SEC_INVENTORIES S
, ORG_ORGANIZATION_DEFINITIONS O
, FND_LOOKUPS DC
, FND_LOOKUPS CT
, FND_LOOKUPS RCT
, CSP_SEC_INVENTORIES RS
, ORG_ORGANIZATION_DEFINITIONS RO
WHERE I.ORGANIZATION_ID = S.ORGANIZATION_ID (+)
AND I.SUBINVENTORY_CODE = S.SECONDARY_INVENTORY_NAME (+)
AND S.CONDITION_TYPE = CT.LOOKUP_CODE (+)
AND CT.LOOKUP_TYPE (+) = 'CSP_CONDITION_TYPE'
AND I.DEFAULT_CODE = DC.LOOKUP_CODE (+)
AND DC.LOOKUP_TYPE (+) = 'CSP_SUBINV_DEFAULT_USE_TYPE'
AND I.ORGANIZATION_ID = O.ORGANIZATION_ID
AND S.RETURN_ORGANIZATION_ID = RO.ORGANIZATION_ID (+)
AND S.RETURN_ORGANIZATION_ID = RS.ORGANIZATION_ID(+)
AND S.RETURN_SUBINVENTORY_NAME = RS.SECONDARY_INVENTORY_NAME(+)
AND RS.CONDITION_TYPE = RCT.LOOKUP_CODE(+)
AND RCT.LOOKUP_TYPE(+) = 'CSP_CONDITION_TYPE'

Columns