eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.POR_RCV_ORD_SV dependencies on RCV_TRANSACTIONS

Line 354: delete from rcv_transactions_interface

350: x_progress := 'groupPoTransaction 040 sql exception ' || substr(SQLERRM,12,200);
351:
352: asn_debug.put_line(x_progress);
353:
354: delete from rcv_transactions_interface
355: where group_id = X_group_id;
356:
357: PO_REQS_CONTROL_SV.commit_changes;
358:

Line 546: delete from rcv_transactions_interface

542: x_progress := 'groupInternalTransaction 040 sql exception ' || substr(SQLERRM,12,200);
543:
544: asn_debug.put_line(x_progress);
545:
546: delete from rcv_transactions_interface
547: where group_id = X_group_id;
548:
549: PO_REQS_CONTROL_SV.commit_changes;
550:

Line 639: INSERT INTO RCV_TRANSACTIONS_INTERFACE (

635: asn_debug.put_line(x_progress);
636: x_progress := 'insert internal transaction, primary_uom= ' || X_primary_uom ||'; primary_qty=' || to_char(X_primary_qty);
637: asn_debug.put_line(x_progress);
638:
639: INSERT INTO RCV_TRANSACTIONS_INTERFACE (
640: INTERFACE_TRANSACTION_ID,
641: GROUP_ID,
642: ORG_ID,
643: LAST_UPDATE_DATE,

Line 706: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,

702: REQUISITION_LINE_ID,
703: COMMENTS,
704: WAYBILL_AIRBILL_NUM,
705: USSGL_TRANSACTION_CODE )
706: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
707: X_group_id,
708: MO_GLOBAL.get_current_org_id,
709: SYSDATE,
710: X_user_id,

Line 952: /* Insert the rows that were checked into RCV_TRANSACTIONS_INTERFACE */

948: end if;
949:
950: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE X_receipt_qty' || X_receipt_qty || ' X_receipt_amt ' || X_receipt_amt);
951:
952: /* Insert the rows that were checked into RCV_TRANSACTIONS_INTERFACE */
953:
954: SELECT POD.DESTINATION_TYPE_CODE,
955: 'PO',
956: NVL(POLL.PROMISED_DATE, POLL.NEED_BY_DATE),

Line 1047: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE Inserting values in RCV_TRANSACTIONS_INTERFACE');

1043: POH.PO_HEADER_ID = x_po_header_id and
1044: POLL.LINE_LOCATION_ID = x_line_location_id and
1045: POD.PO_DISTRIBUTION_ID = X_po_distribution_id;
1046:
1047: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE Inserting values in RCV_TRANSACTIONS_INTERFACE');
1048:
1049: INSERT INTO RCV_TRANSACTIONS_INTERFACE (
1050: INTERFACE_TRANSACTION_ID,
1051: GROUP_ID,

Line 1049: INSERT INTO RCV_TRANSACTIONS_INTERFACE (

1045: POD.PO_DISTRIBUTION_ID = X_po_distribution_id;
1046:
1047: asn_debug.put_line('POR_RCV_ORD_SV.INSERT_RCV_TXN_INTERFACE Inserting values in RCV_TRANSACTIONS_INTERFACE');
1048:
1049: INSERT INTO RCV_TRANSACTIONS_INTERFACE (
1050: INTERFACE_TRANSACTION_ID,
1051: GROUP_ID,
1052: ORG_ID,
1053: LAST_UPDATE_DATE,

Line 1119: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,

1115: WAYBILL_AIRBILL_NUM,
1116: USSGL_TRANSACTION_CODE,
1117: JOB_ID,
1118: MATCHING_BASIS)
1119: SELECT RCV_TRANSACTIONS_INTERFACE_S.NEXTVAL,
1120: X_group_id,
1121: MO_GLOBAL.get_current_org_id,
1122: SYSDATE,
1123: X_user_id,

Line 1244: from rcv_transactions_interface rti

1240:
1241: begin
1242: select org_id
1243: into x_txn_org_id
1244: from rcv_transactions_interface rti
1245: where rti.group_id = x_group_id and rownum = 1;
1246:
1247: asn_debug.put_line('process_transactions x_txn_org_id:' || x_txn_org_id);
1248:

Line 1363: FROM RCV_TRANSACTIONS_INTERFACE RTI, PO_DISTRIBUTIONS_ALL POD

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;

Line 1373: from rcv_transactions_interface

1369: /*
1370: cursor c0 is
1371: select distinct to_organization_id,
1372: vendor_id,waybill_airbill_num
1373: from rcv_transactions_interface
1374: where group_id = X_group_id and shipment_line_id is null;
1375: -- for update of shipment_header_id;
1376: */
1377:

Line 1380: from rcv_transactions_interface

1376: */
1377:
1378: cursor c1 is
1379: select to_organization_id, shipment_header_id, comments, packing_slip,waybill_airbill_num
1380: from rcv_transactions_interface
1381: where group_id = X_group_id and shipment_line_id is not null and
1382: shipment_header_id is not null;
1383:
1384: cursor c2 is

Line 1386: from rcv_transactions_interface trans

1382: shipment_header_id is not null;
1383:
1384: cursor c2 is
1385: select distinct shipment_header_id
1386: from rcv_transactions_interface trans
1387: where group_id = X_group_id and shipment_line_id is not null and
1388: shipment_header_id is not null;
1389:
1390:

Line 1393: X_vendor_id rcv_transactions_interface.vendor_id%type;

1389:
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;

Line 1395: X_to_org_id rcv_transactions_interface.to_organization_id%type;

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;
1399: X_count number := 0;

Line 1417: X_vendor_site_id rcv_transactions_interface.vendor_site_id%type;

1413: x_new_comments VARCHAR2(240);
1414: x_new_packingSlip VARCHAR2(25);
1415: x_new_waybillNum VARCHAR2(20);
1416: x_asn_type VARCHAR2(25);
1417: X_vendor_site_id rcv_transactions_interface.vendor_site_id%type;
1418:
1419: begin
1420:
1421: X_created_by := fnd_global.user_id;

Line 1527: update rcv_transactions_interface

1523: x_line_waybill_airbill_num,
1524: NULL);
1525:
1526: IF x_line_waybill_airbill_num IS NULL THEN
1527: update rcv_transactions_interface
1528: set shipment_header_id = x_shipment_header_id
1529: where group_id = X_group_id
1530: and to_organization_id = x_to_org_id
1531: and vendor_id = x_vendor_id

Line 1536: update rcv_transactions_interface

1532: and shipment_line_id is null
1533: AND waybill_airbill_num IS NULL;
1534: x_req_number := NULL;
1535: ELSE
1536: update rcv_transactions_interface
1537: set shipment_header_id = x_shipment_header_id
1538: where group_id = X_group_id
1539: and to_organization_id = x_to_org_id
1540: and vendor_id = x_vendor_id

Line 1549: FROM rcv_transactions_interface

1545:
1546: BEGIN
1547: SELECT distinct vendor_site_id
1548: INTO X_vendor_site_id
1549: FROM rcv_transactions_interface
1550: WHERE group_id = X_group_id and
1551: shipment_header_id = x_shipment_header_id;
1552:
1553: asn_debug.put_line('vendor_site='||to_char(X_vendor_site_id));

Line 1706: from rcv_transactions_interface rti

1702:
1703: begin
1704: select org_id
1705: into x_txn_org_id
1706: from rcv_transactions_interface rti
1707: where rti.group_id = x_group_id and rownum = 1;
1708:
1709: if (x_txn_org_id <> MO_GLOBAL.get_current_org_id) then
1710: mo_global.set_policy_context(p_access_mode => 'S',

Line 1891: delete from rcv_transactions_interface

1887: if (delete_rows) then
1888:
1889: BEGIN
1890:
1891: delete from rcv_transactions_interface
1892: where group_id = X_group_id;
1893:
1894:
1895: PO_REQS_CONTROL_SV.commit_changes;

Line 1941: FROM RCV_TRANSACTIONS_INTERFACE

1937: BEGIN
1938:
1939: SELECT COUNT(1)
1940: INTO x_rec_count
1941: FROM RCV_TRANSACTIONS_INTERFACE
1942: WHERE group_id = x_group_id;
1943:
1944: IF (x_rec_count = 0) THEN
1945:

Line 1968: from rcv_transactions rcv,po_line_locations_all poll,

1964: select distinct nvl(pod.wf_item_key, rcv.po_header_id ||';'||
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;