VIEW: APPS.PO_SHIPMENTS_AP_V

Source

View Text - Preformatted

SELECT POLL.SHIPMENT_NUM SHIPMENT_NUM , HRTL.LOCATION_CODE LOCATION_CODE , POR.RELEASE_NUM RELEASE_NUM , POL.LINE_NUM LINE_NUM , POR.PO_RELEASE_ID PO_RELEASE_ID , POLL.LINE_LOCATION_ID LINE_LOCATION_ID , POL.PO_LINE_ID LINE_ID , POLL.PO_HEADER_ID PO_HEADER_ID ,POLL.ORG_ID FROM PO_LINE_LOCATIONS POLL, PO_RELEASES_ALL POR, PO_LINES_ALL POL, HR_LOCATIONS_ALL_TL HRTL, HR_LOCATIONS_ALL HRL WHERE POLL.SHIP_TO_LOCATION_ID = HRTL.LOCATION_ID(+) AND POLL.SHIP_TO_LOCATION_ID IS NOT NULL AND HRTL.LANGUAGE(+)=USERENV('LANG') AND NVL(HRL.BUSINESS_GROUP_ID(+),NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID, -99) ) =NVL (HR_GENERAL.GET_BUSINESS_GROUP_ID, -99) AND HRL.LOCATION_ID(+) =HRTL.LOCATION_ID AND POLL.PO_RELEASE_ID = POR.PO_RELEASE_ID (+) AND POLL.PO_LINE_ID = POL.PO_LINE_ID

View Text - HTML Formatted

SELECT POLL.SHIPMENT_NUM SHIPMENT_NUM
, HRTL.LOCATION_CODE LOCATION_CODE
, POR.RELEASE_NUM RELEASE_NUM
, POL.LINE_NUM LINE_NUM
, POR.PO_RELEASE_ID PO_RELEASE_ID
, POLL.LINE_LOCATION_ID LINE_LOCATION_ID
, POL.PO_LINE_ID LINE_ID
, POLL.PO_HEADER_ID PO_HEADER_ID
, POLL.ORG_ID
FROM PO_LINE_LOCATIONS POLL
, PO_RELEASES_ALL POR
, PO_LINES_ALL POL
, HR_LOCATIONS_ALL_TL HRTL
, HR_LOCATIONS_ALL HRL
WHERE POLL.SHIP_TO_LOCATION_ID = HRTL.LOCATION_ID(+)
AND POLL.SHIP_TO_LOCATION_ID IS NOT NULL
AND HRTL.LANGUAGE(+)=USERENV('LANG')
AND NVL(HRL.BUSINESS_GROUP_ID(+)
, NVL(HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99) ) =NVL (HR_GENERAL.GET_BUSINESS_GROUP_ID
, -99)
AND HRL.LOCATION_ID(+) =HRTL.LOCATION_ID
AND POLL.PO_RELEASE_ID = POR.PO_RELEASE_ID (+)
AND POLL.PO_LINE_ID = POL.PO_LINE_ID