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.

APPS.INV_RCV_STD_RCPT_APIS dependencies on RCV_TRANSACTIONS_INTERFACE

Line 343: SELECT rcv_transactions_interface_s.NEXTVAL

339: -- pass that to quality. So using that if it is generated.
340: IF l_rcv_transaction_rec.interface_transaction_id IS NOT NULL THEN
341: l_interface_transaction_id := l_rcv_transaction_rec.interface_transaction_id;
342: ELSE
343: SELECT rcv_transactions_interface_s.NEXTVAL
344: INTO l_interface_transaction_id
345: FROM DUAL;
346: END IF;
347:

Line 775: -- rcv_transactions_interface table

771:
772: -- insert this record into RTI
773: -- Insert the row into the interface table using
774: -- the table handler call for the
775: -- rcv_transactions_interface table
776:
777: -- For inter-org shipment and ASN receipt, shipment header id is set already
778: -- For Normal PO, we generate a shipment header id at this point,
779: -- then use the same when actually inserting record into RSH.

Line 930: INSERT INTO rcv_transactions_interface

926: END IF;
927: END IF;
928: print_debug('l_express_transaction: ' || l_express_transaction,4);
929: -- bug 4697949 end
930: INSERT INTO rcv_transactions_interface
931: (
932: interface_transaction_id
933: , GROUP_ID
934: , last_update_date

Line 1310: UPDATE rcv_transactions_interface

1306: INTO v_lcm_ship_line_id, v_unit_landed_cost
1307: FROM rcv_shipment_lines
1308: WHERE shipment_line_id = l_shipment_line_id;
1309:
1310: UPDATE rcv_transactions_interface
1311: SET lcm_shipment_line_id = v_lcm_ship_line_id,
1312: unit_landed_cost = v_unit_landed_cost
1313: WHERE interface_transaction_id = l_interface_transaction_id
1314: AND to_organization_id = l_to_org_id;

Line 1317: UPDATE rcv_transactions_interface

1313: WHERE interface_transaction_id = l_interface_transaction_id
1314: AND to_organization_id = l_to_org_id;
1315:
1316: ELSE
1317: UPDATE rcv_transactions_interface
1318: SET processing_status_code = 'LC_PENDING',
1319: PROCESSING_MODE_CODE = 'BATCH'
1320: WHERE interface_transaction_id = l_interface_transaction_id
1321: AND to_organization_id = l_to_org_id;

Line 1340: FROM rcv_transactions_interface

1336: BEGIN
1337: SELECT secondary_uom_code, secondary_unit_of_measure,
1338: secondary_quantity
1339: INTO t_sec_uom_code, t_sec_uom, t_sec_qty
1340: FROM rcv_transactions_interface
1341: WHERE interface_transaction_id = l_interface_transaction_id;
1342: print_debug('t_sec_uom_code ' || t_sec_uom_code, 1);
1343: print_debug('t_sec_uom ' || t_sec_uom, 1);
1344: print_debug('t_sec_qty ' || t_sec_qty, 1);

Line 2212: SELECT rcv_transactions_interface_s.NEXTVAL

2208: IF NVL(l_qa_availability, fnd_api.g_false) = fnd_api.g_true THEN
2209: l_qa_routing_id := 2;
2210:
2211: BEGIN
2212: SELECT rcv_transactions_interface_s.NEXTVAL
2213: INTO l_rcv_transaction_rec.interface_transaction_id
2214: FROM DUAL;
2215:
2216: l_progress := '83';

Line 4751: SELECT rcv_transactions_interface_s.NEXTVAL

4747: l_rcv_rcpt_rec.inspection_required_flag := 'Y';
4748: l_rcv_rcpt_rec.routing_id := 2;
4749:
4750: BEGIN
4751: SELECT rcv_transactions_interface_s.NEXTVAL
4752: INTO l_rcv_transaction_rec.interface_transaction_id
4753: FROM DUAL;
4754:
4755: l_progress := '83';

Line 5625: from mtl_serial_numbers_interface msni, rcv_transactions_interface rti,

5621: END IF;
5622:
5623: select count(1) into
5624: l_msni_count
5625: from mtl_serial_numbers_interface msni, rcv_transactions_interface rti,
5626: wms_license_plate_numbers lpn, rcv_shipment_headers rsh,
5627: mtl_serial_numbers msn -- Bug 16517269
5628: where rti.interface_transaction_id = msni.product_transaction_id
5629: and rsh.shipment_header_id = p_shipment_header_id

Line 5870: FROM rcv_transactions_interface rti

5866: /* Group BY LPN_ID is changed for Express Receipts */
5867: /* Also duplicate print of LPN labels is avoided */
5868: CURSOR c_rti_txn_id IS
5869: SELECT MAX(rti.interface_transaction_id)
5870: FROM rcv_transactions_interface rti
5871: WHERE rti.GROUP_ID = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
5872: GROUP BY DECODE(p_source_type,
5873: 'ASNEXP', rti.interface_transaction_id
5874: , 'SHIPMENTEXP', rti.interface_transaction_id, NULL);

Line 6707: FROM RCV_TRANSACTIONS_INTERFACE

6703: BEGIN
6704:
6705: SELECT PROCESSING_STATUS_CODE
6706: INTO v_processing_status_code
6707: FROM RCV_TRANSACTIONS_INTERFACE
6708: WHERE HEADER_INTERFACE_ID in
6709: (SELECT HEADER_INTERFACE_ID
6710: FROM RCV_HEADERS_INTERFACE
6711: WHERE receipt_num = p_lcmReceiptNum

Line 7276: FROM rcv_transactions_interface

7272: END IF;
7273:
7274: SELECT transaction_status_code
7275: INTO l_process_status
7276: FROM rcv_transactions_interface
7277: WHERE group_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id
7278: AND ROWNUM = 1;
7279: ELSE
7280: SELECT transaction_status_code

Line 7282: FROM rcv_transactions_interface

7278: AND ROWNUM = 1;
7279: ELSE
7280: SELECT transaction_status_code
7281: INTO l_process_status
7282: FROM rcv_transactions_interface
7283: WHERE shipment_header_id = g_shipment_header_id
7284: AND ROWNUM < 2;
7285: END IF;
7286:

Line 7312: UPDATE rcv_transactions_interface

7308: (inv_rcv_common_apis.g_po_patch_level >= inv_rcv_common_apis.g_patchset_j_po)) THEN
7309: IF (l_debug = 1) THEN
7310: print_debug('Calling to insert RHI for J code', 4);
7311: END IF;
7312: UPDATE rcv_transactions_interface
7313: SET shipment_num = p_shipment_num
7314: , freight_carrier_code = p_freight_carrier_code
7315: , bill_of_lading = p_bill_of_lading
7316: , packing_slip = p_packing_slip

Line 7321: UPDATE rcv_transactions_interface

7317: , num_of_containers = p_num_of_containers
7318: , waybill_airbill_num = p_waybill_airbill_num
7319: WHERE group_id = inv_rcv_common_apis.g_rcv_global_var.interface_group_id;
7320: ELSE
7321: UPDATE rcv_transactions_interface
7322: SET shipment_num = p_shipment_num
7323: , freight_carrier_code = p_freight_carrier_code
7324: , bill_of_lading = p_bill_of_lading
7325: , packing_slip = p_packing_slip

Line 7940: FROM rcv_transactions_interface rti

7936: l_counter NUMBER := 0;
7937: l_receipt_number VARCHAR2(30);
7938: CURSOR c_rti_txn_id(p_shipment_header_id NUMBER) IS
7939: SELECT rti.interface_transaction_id
7940: FROM rcv_transactions_interface rti
7941: WHERE rti.shipment_header_id = p_shipment_header_id;
7942: BEGIN
7943: l_progress := '10';
7944: l_receipt_number := p_receipt_num; --bug 3630412

Line 9530: FROM rcv_transactions_interface

9526: SELECT count(1)
9527: INTO l_partial_rcpt
9528: FROM dual
9529: WHERE EXISTS ( SELECT 1
9530: FROM rcv_transactions_interface
9531: WHERE shipment_header_id = p_shipment_header_id
9532: AND to_organization_id = p_rcv_org_id
9533: );
9534: EXCEPTION

Line 9662: rcv_transactions_interface rti

9658: BEGIN
9659: SELECT NVL(SUM(mtli.primary_quantity),0)
9660: INTO l_mtli_primary_quantity
9661: FROM mtl_transaction_lots_interface mtli,
9662: rcv_transactions_interface rti
9663: WHERE rti.processing_status_code <> 'ERROR'
9664: AND rti.transaction_status_code <> 'ERROR'
9665: AND rti.to_organization_id = p_rcv_org_id
9666: AND rti.item_id = p_inventory_item_id

Line 9813: rcv_transactions_interface rti

9809: BEGIN
9810: SELECT NVL(SUM(mtli.primary_quantity),0)
9811: INTO l_mtli_primary_quantity
9812: FROM mtl_transaction_lots_interface mtli,
9813: rcv_transactions_interface rti
9814: WHERE rti.processing_status_code <> 'ERROR'
9815: AND rti.transaction_status_code <> 'ERROR'
9816: AND rti.to_organization_id = p_rcv_org_id
9817: AND rti.item_id = p_inventory_item_id