VIEW: APPS.JTM_CSP_REQUIREMENTS_V

Source

View Text - Preformatted

SELECT A.ACCESS_ID , B.REQUIREMENT_LINE_ID , B.REQUIREMENT_HEADER_ID , B.INVENTORY_ITEM_ID , B.UOM_CODE , B.REQUIRED_QUANTITY , B.SHIP_COMPLETE_FLAG , B.LIKELIHOOD , B.REVISION , B.SOURCE_ORGANIZATION_ID , B.SOURCE_SUBINVENTORY , B.ORDERED_QUANTITY , B.ORDER_LINE_ID , B.RESERVATION_ID , B.LOCAL_RESERVATION_ID , B.ORDER_BY_DATE , B.ARRIVAL_DATE , B.ITEM_SCRATCHPAD , 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_LINES B , JTM_CSP_REQ_LINES_ACC A WHERE B.REQUIREMENT_LINE_ID = A.REQUIREMENT_LINE_ID AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID

View Text - HTML Formatted

SELECT A.ACCESS_ID
, B.REQUIREMENT_LINE_ID
, B.REQUIREMENT_HEADER_ID
, B.INVENTORY_ITEM_ID
, B.UOM_CODE
, B.REQUIRED_QUANTITY
, B.SHIP_COMPLETE_FLAG
, B.LIKELIHOOD
, B.REVISION
, B.SOURCE_ORGANIZATION_ID
, B.SOURCE_SUBINVENTORY
, B.ORDERED_QUANTITY
, B.ORDER_LINE_ID
, B.RESERVATION_ID
, B.LOCAL_RESERVATION_ID
, B.ORDER_BY_DATE
, B.ARRIVAL_DATE
, B.ITEM_SCRATCHPAD
, 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_LINES B
, JTM_CSP_REQ_LINES_ACC A
WHERE B.REQUIREMENT_LINE_ID = A.REQUIREMENT_LINE_ID
AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID