[Home] [Help]
406: -- changed cursor re bug 2876139
407: -- changed cursor re bug 9907309 - not fetching end dated buyer users.
408: CURSOR asn_buyer(v_shipment_num varchar2,v_vendor_id number,v_vendor_site_id number) is
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
789: item_num varchar2(80),
790: item_desc po_lines_all.item_description%TYPE,
791: uom po_lines_all.unit_meas_lookup_code%TYPE,
792: order_qty po_line_locations_all.quantity%TYPE,
793: ship_qty rcv_transactions_interface.quantity%TYPE,
794: --rcvd_qty po_line_locations_all.quantity_received%type,
795: rcvd_qty NUMBER,
796: ship_to rcv_transactions_interface.ship_to_location_code%type,
797: ship_to_org org_organization_definitions.ORGANIZATION_CODE%type
792: order_qty po_line_locations_all.quantity%TYPE,
793: ship_qty rcv_transactions_interface.quantity%TYPE,
794: --rcvd_qty po_line_locations_all.quantity_received%type,
795: rcvd_qty NUMBER,
796: ship_to rcv_transactions_interface.ship_to_location_code%type,
797: ship_to_org org_organization_definitions.ORGANIZATION_CODE%type
798: );
799:
800: NL VARCHAR2(1) := fnd_global.newline;
854: pll.quantity_received QUANTITY_RECEIVED,
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