[Home] [Help]
409: SELECT NVL(POR.AGENT_ID,POH.AGENT_ID)
410: FROM RCV_TRANSACTIONS_INTERFACE RTI,
411: RCV_HEADERS_INTERFACE RHI,
412: PO_HEADERS_ALL POH,
413: PO_RELEASES_ALL POR,
414: WF_USERS WUSR
415: WHERE POH.PO_HEADER_ID = RTI.PO_HEADER_ID AND
416: RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
417: POH.PO_HEADER_ID = POR.PO_HEADER_ID (+) AND
428: SELECT NVL(POR.AGENT_ID,POH.AGENT_ID)
429: FROM RCV_SHIPMENT_LINES RSL,
430: RCV_SHIPMENT_HEADERS RSH,
431: PO_HEADERS_ALL POH,
432: PO_RELEASES_ALL POR,
433: WF_USERS WUSR
434: WHERE
435: POH.PO_HEADER_ID = RSL.PO_HEADER_ID AND
436: RSL.SHIPMENT_HEADER_ID= RSH.SHIPMENT_HEADER_ID AND
855: NVL( HRL.LOCATION_CODE,
856: SUBSTR(RTRIM(HZ.ADDRESS1)||'-'||RTRIM(HZ.CITY),1,20)) ship_to_location_code,
857: ood.ORGANIZATION_CODE ORGANIZATION_CODE
858: FROM rcv_transactions_interface rti, rcv_headers_interface rhi ,
859: org_organization_definitions ood,po_releases_all prl,
860: po_line_locations_all pll,po_lines_all pola,po_headers_all ph,
861: hr_locations_all_tl hrl, hz_locations hz
862: WHERE rhi.header_interface_id=rti.header_interface_id and
863: rhi.shipment_num= p_shipment_num and
887: NVL( HRL.LOCATION_CODE,
888: SUBSTR(RTRIM(HZ.ADDRESS1)||'-'||RTRIM(HZ.CITY),1,20)) ship_to_location_code,
889: ood.ORGANIZATION_CODE ORGANIZATION_CODE
890: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh ,
891: org_organization_definitions ood,po_releases_all prl,
892: po_line_locations_all pll,po_lines_all pola,po_headers_all ph,
893: hr_locations_all_tl hrl,hz_locations hz
894: WHERE rsh.shipment_header_id=rsl.shipment_header_id and
895: rsh.shipment_num= p_shipment_num and