[Home] [Help]
324: SELECT NVL(POR.AGENT_ID,POH.AGENT_ID)
325: FROM RCV_TRANSACTIONS_INTERFACE RTI,
326: RCV_HEADERS_INTERFACE RHI,
327: PO_HEADERS_ALL POH,
328: PO_RELEASES_ALL POR
329: WHERE POH.PO_HEADER_ID = RTI.PO_HEADER_ID AND
330: RHI.HEADER_INTERFACE_ID = RTI.HEADER_INTERFACE_ID AND
331: POH.PO_HEADER_ID = POR.PO_HEADER_ID (+) AND
332: RHI.SHIPMENT_NUM = v_shipment_num AND
336: SELECT NVL(POR.AGENT_ID,POH.AGENT_ID)
337: FROM RCV_SHIPMENT_LINES RSL,
338: RCV_SHIPMENT_HEADERS RSH,
339: PO_HEADERS_ALL POH,
340: PO_RELEASES_ALL POR
341: WHERE
342: POH.PO_HEADER_ID = RSL.PO_HEADER_ID AND
343: RSL.SHIPMENT_HEADER_ID= RSH.SHIPMENT_HEADER_ID AND
344: POH.PO_HEADER_ID = POR.PO_HEADER_ID (+) AND
679: NVL( HRL.LOCATION_CODE,
680: SUBSTR(RTRIM(HZ.ADDRESS1)||'-'||RTRIM(HZ.CITY),1,20)) ship_to_location_code,
681: ood.ORGANIZATION_CODE ORGANIZATION_CODE
682: FROM rcv_transactions_interface rti, rcv_headers_interface rhi ,
683: org_organization_definitions ood,po_releases_all prl,
684: po_line_locations_all pll,po_lines_all pola,po_headers_all ph,
685: hr_locations_all_tl hrl, hz_locations hz
686: WHERE rhi.header_interface_id=rti.header_interface_id and
687: rhi.shipment_num= p_shipment_num and
711: NVL( HRL.LOCATION_CODE,
712: SUBSTR(RTRIM(HZ.ADDRESS1)||'-'||RTRIM(HZ.CITY),1,20)) ship_to_location_code,
713: ood.ORGANIZATION_CODE ORGANIZATION_CODE
714: FROM rcv_shipment_lines rsl, rcv_shipment_headers rsh ,
715: org_organization_definitions ood,po_releases_all prl,
716: po_line_locations_all pll,po_lines_all pola,po_headers_all ph,
717: hr_locations_all_tl hrl,hz_locations hz
718: WHERE rsh.shipment_header_id=rsl.shipment_header_id and
719: rsh.shipment_num= p_shipment_num and