[Home] [Help]
688:
689: BEGIN
690: SELECT Count(DISTINCT poh.vendor_site_id),poh.vendor_site_id
691: INTO count1,x_ven_site_id
692: FROM rcv_transactions_interface rti, po_headers poh
693: WHERE ((rti.document_num IS NOT NULL AND rti.document_num = poh.segment1) OR
694: (rti.po_header_id is not null AND rti.po_header_id = poh.po_header_id))
695: AND rti.header_interface_id = p_header_record.header_record.header_interface_id
696: GROUP BY poh.vendor_site_id;
1071: IF NVL(p_header_record.header_record.asn_type, 'STD') IN('ASN', 'ASBN','WC', 'LCM') THEN /* lcm changes */ --{
1072: BEGIN
1073: SELECT COUNT(*)
1074: INTO x_in_this_op_unit
1075: FROM po_headers poh,
1076: rcv_transactions_interface rti
1077: WHERE poh.vendor_id = p_header_record.header_record.vendor_id
1078: AND poh.segment1 = rti.document_num
1079: AND rti.header_interface_id = p_header_record.header_record.header_interface_id
1874: -- transaction processor will not look at it.
1875:
1876: /*
1877: * Populate the org_id column in rcv_transactions_interface with org_id from
1878: * po_headers_all table
1879: */
1880:
1881: INSERT INTO rcv_transactions_interface
1882: (interface_transaction_id,
1947: rsl.destination_type_code,
1948: p_header_record.header_record.processing_request_id,
1949: poh.org_id
1950: FROM rcv_shipment_lines rsl,
1951: po_headers_all poh
1952: WHERE rsl.shipment_header_id = p_header_record.header_record.receipt_header_id
1953: AND rsl.shipment_line_status_code <> 'CANCELLED'
1954: AND rsl.po_header_id = poh.po_header_id
1955: AND NOT EXISTS(SELECT 'x'