VIEW: APPS.JTM_CSP_REQUIREMENT_HEADERS_V

Source

View Text - Preformatted

SELECT A.ACCESS_ID , B.REQUIREMENT_HEADER_ID , B.CREATION_DATE , B.OPEN_REQUIREMENT , B.ADDRESS_TYPE , B.SHIP_TO_LOCATION_ID , B.TIMEZONE_ID , B.TASK_ID , B.TASK_ASSIGNMENT_ID , B.RESOURCE_TYPE , B.RESOURCE_ID , B.SHIPPING_METHOD_CODE , B.NEED_BY_DATE , B.DESTINATION_ORGANIZATION_ID , B.DESTINATION_SUBINVENTORY , B.ORDER_TYPE_ID , B.PARTS_DEFINED , NULL AS ATTRIBUTE_CATEGORY , NULL AS ATTRIBUTE1 , NULL AS ATTRIBUTE2 , NULL AS ATTRIBUTE3 , NULL AS ATTRIBUTE4 , NULL AS ATTRIBUTE5 , NULL AS ATTRIBUTE6 , NULL AS ATTRIBUTE7 , NULL AS ATTRIBUTE8 , NULL AS ATTRIBUTE9 , NULL AS ATTRIBUTE10 , NULL AS ATTRIBUTE11 , NULL AS ATTRIBUTE12 , NULL AS ATTRIBUTE13 , NULL AS ATTRIBUTE14 , NULL AS ATTRIBUTE15 FROM CSP_REQUIREMENT_HEADERS B , JTM_CSP_REQ_HEADERS_ACC A WHERE B.REQUIREMENT_HEADER_ID = A.REQUIREMENT_HEADER_ID AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT A.ACCESS_ID
, B.REQUIREMENT_HEADER_ID
, B.CREATION_DATE
, B.OPEN_REQUIREMENT
, B.ADDRESS_TYPE
, B.SHIP_TO_LOCATION_ID
, B.TIMEZONE_ID
, B.TASK_ID
, B.TASK_ASSIGNMENT_ID
, B.RESOURCE_TYPE
, B.RESOURCE_ID
, B.SHIPPING_METHOD_CODE
, B.NEED_BY_DATE
, B.DESTINATION_ORGANIZATION_ID
, B.DESTINATION_SUBINVENTORY
, B.ORDER_TYPE_ID
, B.PARTS_DEFINED
, NULL AS ATTRIBUTE_CATEGORY
, NULL AS ATTRIBUTE1
, NULL AS ATTRIBUTE2
, NULL AS ATTRIBUTE3
, NULL AS ATTRIBUTE4
, NULL AS ATTRIBUTE5
, NULL AS ATTRIBUTE6
, NULL AS ATTRIBUTE7
, NULL AS ATTRIBUTE8
, NULL AS ATTRIBUTE9
, NULL AS ATTRIBUTE10
, NULL AS ATTRIBUTE11
, NULL AS ATTRIBUTE12
, NULL AS ATTRIBUTE13
, NULL AS ATTRIBUTE14
, NULL AS ATTRIBUTE15
FROM CSP_REQUIREMENT_HEADERS B
, JTM_CSP_REQ_HEADERS_ACC A
WHERE B.REQUIREMENT_HEADER_ID = A.REQUIREMENT_HEADER_ID
AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID