[Home] [Help]
910: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE x_employee_id :' || x_employee_id );
911:
912: SELECT POL.MATCHING_BASIS, POL.JOB_ID
913: INTO X_MATCHING_BASIS, X_JOB_ID
914: FROM PO_LINES_ALL POL, PO_DISTRIBUTIONS_ALL POD
915: WHERE POL.PO_LINE_ID = POD.PO_LINE_ID
916: AND POD.PO_DISTRIBUTION_ID = X_PO_DISTRIBUTION_ID;
917:
918: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE X_MATCHING_BASIS' || X_MATCHING_BASIS);
1028: --Bug 8893932 PO RECEIVED FROM IPROCUREMENT DOESNT POPULATE COUNTRY OF ORIGIN
1029: l_country_of_origin
1030: FROM MTL_SYSTEM_ITEMS MSI,
1031: PO_LINES_ALL POL,
1032: PO_DISTRIBUTIONS_ALL POD,
1033: PO_HEADERS_ALL POH,
1034: PO_LINE_LOCATIONS_ALL POLL
1035: WHERE
1036: NVL(POLL.APPROVED_FLAG,'N') = 'Y' AND
1366:
1367: cursor c0 is
1368: SELECT RTI.TO_ORGANIZATION_ID,
1369: RTI.VENDOR_ID, RTI.WAYBILL_AIRBILL_NUM, POD.ORG_ID
1370: FROM RCV_TRANSACTIONS_INTERFACE RTI, PO_DISTRIBUTIONS_ALL POD
1371: WHERE GROUP_ID = X_GROUP_ID AND
1372: SHIPMENT_LINE_ID IS NULL AND
1373: RTI.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID
1374: GROUP BY RTI.TO_ORGANIZATION_ID, RTI.VENDOR_ID, RTI.WAYBILL_AIRBILL_NUM, POD.ORG_ID;
1397:
1398: X_sysdate date := SYSDATE;
1399: X_userid number := 0;
1400: X_vendor_id rcv_transactions_interface.vendor_id%type;
1401: X_org_id PO_DISTRIBUTIONS_ALL.ORG_ID%type;
1402: X_to_org_id rcv_transactions_interface.to_organization_id%type;
1403: X_receipt_num rcv_shipment_headers.receipt_num%type;
1404: X_created_by rcv_shipment_headers.created_by%type;
1405: X_last_update_login rcv_shipment_headers.last_update_login%type;
1975:
1976: cursor C1 is
1977: select distinct nvl(pod.wf_item_key,wf.ITEM_KEY)
1978: from rcv_transactions rcv,po_line_locations_all poll,
1979: po_distributions_all pod,wf_items wf
1980: where group_id = x_group_id and
1981: poll.line_location_id = rcv.po_line_location_id AND
1982: pod.po_distribution_id = rcv.po_distribution_id
1983: AND wf.item_type = 'PORCPT' AND