[Home] [Help]
909: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE x_employee_id :' || x_employee_id );
910:
911: SELECT POL.MATCHING_BASIS, POL.JOB_ID
912: INTO X_MATCHING_BASIS, X_JOB_ID
913: FROM PO_LINES_ALL POL, PO_DISTRIBUTIONS_ALL POD
914: WHERE POL.PO_LINE_ID = POD.PO_LINE_ID
915: AND POD.PO_DISTRIBUTION_ID = X_PO_DISTRIBUTION_ID;
916:
917: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE X_MATCHING_BASIS' || X_MATCHING_BASIS);
1023: l_wip_resource_seq_num,
1024: l_bom_resource_id
1025: FROM MTL_SYSTEM_ITEMS MSI,
1026: PO_LINES_ALL POL,
1027: PO_DISTRIBUTIONS_ALL POD,
1028: PO_HEADERS_ALL POH,
1029: PO_LINE_LOCATIONS_ALL POLL
1030: WHERE
1031: NVL(POLL.APPROVED_FLAG,'N') = 'Y' AND
1359:
1360: cursor c0 is
1361: SELECT RTI.TO_ORGANIZATION_ID,
1362: RTI.VENDOR_ID, RTI.WAYBILL_AIRBILL_NUM, POD.ORG_ID
1363: FROM RCV_TRANSACTIONS_INTERFACE RTI, PO_DISTRIBUTIONS_ALL POD
1364: WHERE GROUP_ID = X_GROUP_ID AND
1365: SHIPMENT_LINE_ID IS NULL AND
1366: RTI.PO_DISTRIBUTION_ID = POD.PO_DISTRIBUTION_ID
1367: GROUP BY RTI.TO_ORGANIZATION_ID, RTI.VENDOR_ID, RTI.WAYBILL_AIRBILL_NUM, POD.ORG_ID;
1390:
1391: X_sysdate date := SYSDATE;
1392: X_userid number := 0;
1393: X_vendor_id rcv_transactions_interface.vendor_id%type;
1394: X_org_id PO_DISTRIBUTIONS_ALL.ORG_ID%type;
1395: X_to_org_id rcv_transactions_interface.to_organization_id%type;
1396: X_receipt_num rcv_shipment_headers.receipt_num%type;
1397: X_created_by rcv_shipment_headers.created_by%type;
1398: X_last_update_login rcv_shipment_headers.last_update_login%type;
1965: rcv.deliver_to_person_id || ';' ||
1966: to_char(nvl(poll.promised_date,
1967: poll.need_by_date), 'DD-MON-YYYY'))
1968: from rcv_transactions rcv,po_line_locations_all poll,
1969: po_distributions_all pod
1970: where group_id = x_group_id and
1971: poll.line_location_id = rcv.po_line_location_id AND
1972: pod.po_distribution_id = rcv.po_distribution_id;
1973: