View: CSP_REQUIREMENT_HEADERS_V

Product:	CSP - Spares Management
Description:	Information about parts requirement headers
Implementation/DBA Data:	APPS.CSP_REQUIREMENT_HEADERS_V

View Text

SELECT CRH.REQUIREMENT_HEADER_ID
, CRH.CREATED_BY
, CRH.CREATION_DATE
, CRH.LAST_UPDATED_BY
, CRH.LAST_UPDATE_DATE
, CRH.LAST_UPDATE_LOGIN
, CRH.OPEN_REQUIREMENT
, CRH.ADDRESS_TYPE
, CRH.SHIP_TO_LOCATION_ID
, JTV.SOURCE_OBJECT_NAME SERVICE_REQUEST
, CRH.TASK_ID
, JTV.TASK_NUMBER
, CRH.TASK_ASSIGNMENT_ID
, DECODE(CRH.TASK_ASSIGNMENT_ID
, NULL
, CRH.RESOURCE_TYPE
, JTA.RESOURCE_TYPE_CODE)
, DECODE(CRH.TASK_ASSIGNMENT_ID
, NULL
, CRH.RESOURCE_ID
, JTA.RESOURCE_ID)
, CRH.NEED_BY_DATE
, CRH.DESTINATION_ORGANIZATION_ID
, OOD.ORGANIZATION_CODE
, CRH.DESTINATION_SUBINVENTORY
, CRH.PARTS_DEFINED
, CRH.ORDER_TYPE_ID
, OTT.NAME ORDER_TYPE_NAME
, CRH.ATTRIBUTE_CATEGORY
, CRH.ATTRIBUTE1
, CRH.ATTRIBUTE2
, CRH.ATTRIBUTE3
, CRH.ATTRIBUTE4
, CRH.ATTRIBUTE5
, CRH.ATTRIBUTE6
, CRH.ATTRIBUTE7
, CRH.ATTRIBUTE8
, CRH.ATTRIBUTE9
, CRH.ATTRIBUTE10
, CRH.ATTRIBUTE11
, CRH.ATTRIBUTE12
, CRH.ATTRIBUTE13
, CRH.ATTRIBUTE14
, CRH.ATTRIBUTE15
FROM OE_TRANSACTION_TYPES OTT
, JTF_TASK_ASSIGNMENTS JTA
, JTF_TASKS_VL JTV
, ORG_ORGANIZATION_DEFINITIONS OOD
, CSP_REQUIREMENT_HEADERS CRH
WHERE OTT.TRANSACTION_TYPE_ID(+) = CRH.ORDER_TYPE_ID
AND NVL(OTT.TRANSACTION_TYPE_CODE
, 'ORDER') = 'ORDER'
AND JTA.TASK_ASSIGNMENT_ID(+) = CRH.TASK_ASSIGNMENT_ID
AND NVL(JTV.SOURCE_OBJECT_TYPE_CODE
, 'SR') = 'SR'
AND JTV.TASK_ID(+) = CRH.TASK_ID
AND OOD.ORGANIZATION_ID(+) = CRH.DESTINATION_ORGANIZATION_ID

Columns