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_TRANSFER_APIS dependencies on RCV_TRANSACTIONS

Line 4: --Transaction UOM Code in RTI. Need this because the rcv_transactions

1: PACKAGE BODY INV_RCV_STD_TRANSFER_APIS AS
2: /* $Header: INVSTDTB.pls 120.11 2006/11/22 05:40:13 anviswan ship $ */
3:
4: --Transaction UOM Code in RTI. Need this because the rcv_transactions
5: --record type does not store the uom_code
6: g_transfer_uom_code MTL_ITEM_UOMS_VIEW.UOM_CODE%TYPE;
7:
8: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_RCV_STD_TRANSFER_APIS';

Line 28: * Helper routing to create a new record in RCV_TRANSACTIONS_INTERFACE

24:
25: /*----------------------------------------------------------------------------*
26: * FUNCTION: insert_interface_code
27: * Description:
28: * Helper routing to create a new record in RCV_TRANSACTIONS_INTERFACE
29: *
30: * Input Parameters:
31: * p_rcv_transactions_rec - Record containing the values for RTI
32: *

Line 31: * p_rcv_transactions_rec - Record containing the values for RTI

27: * Description:
28: * Helper routing to create a new record in RCV_TRANSACTIONS_INTERFACE
29: *
30: * Input Parameters:
31: * p_rcv_transactions_rec - Record containing the values for RTI
32: *
33: * Returns: NUMBER - transaction_interface_id
34: *---------------------------------------------------------------------------*/
35:

Line 41: l_destination_context RCV_TRANSACTIONS_INTERFACE.DESTINATION_CONTEXT%TYPE := 'RECEIVING';

37: p_rcv_transaction_rec INV_RCV_STD_DELIVER_APIS.RCVTXN_TRANSACTION_REC_TP
38: )
39: RETURN NUMBER IS
40: l_interface_transaction_id NUMBER;
41: l_destination_context RCV_TRANSACTIONS_INTERFACE.DESTINATION_CONTEXT%TYPE := 'RECEIVING';
42: l_parent_transaction_id NUMBER := p_rcv_transaction_rec.rcv_transaction_id;
43: l_movement_id NUMBER;
44: l_bom_resource_id NUMBER := NULL;
45: l_group_id NUMBER := inv_rcv_common_apis.g_rcv_global_var.interface_group_id;

Line 67: SELECT rcv_transactions_interface_s.NEXTVAL

63: print_debug('Entered insert_interface_code 10 : ' || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 1);
64: print_debug(' parent_transaction_id => '||p_rcv_transaction_rec.rcv_transaction_id,1);
65:
66: --Generate a new value for RTID from the sequence
67: SELECT rcv_transactions_interface_s.NEXTVAL
68: INTO l_interface_transaction_id
69: FROM sys.DUAL;
70:
71: l_parent_transaction_id := p_rcv_transaction_rec.rcv_transaction_id;

Line 82: FROM rcv_transactions rt

78: , rt.task_id
79: INTO l_movement_id
80: , l_project_id
81: , l_task_id
82: FROM rcv_transactions rt
83: WHERE rt.transaction_id = l_parent_transaction_id
84: AND ROWNUM < 2;
85: EXCEPTION
86: WHEN OTHERS THEN

Line 160: INSERT INTO rcv_transactions_interface

156: END IF;
157:
158: BEGIN
159: --At last, now insert the record into RTI
160: INSERT INTO rcv_transactions_interface
161: (
162: receipt_source_code
163: , interface_transaction_id
164: , group_id

Line 648: --Now, insert the RCV_TRANSACTIONS_INTERFACE record

644: p_rcv_transaction_rec.wip_operation_seq_num := NULL;
645: p_rcv_transaction_rec.wip_resource_seq_num := NULL;
646: p_rcv_transaction_rec.wip_repetitive_schedule_id := NULL;
647:
648: --Now, insert the RCV_TRANSACTIONS_INTERFACE record
649: l_progress := 50;
650:
651: IF (l_debug = 1) THEN
652: print_debug('Inserting the RTI for TRANSFER transaction', 4);

Line 1193: FROM rcv_transactions rt

1189: , rt.secondary_unit_of_measure secondary_uom --OPM Convergence
1190: --The following columns are needed for matching in cases where no LPN is involved
1191: , rs.to_subinventory from_subinventory_code
1192: , rs.to_locator_id from_locator_id
1193: FROM rcv_transactions rt
1194: , rcv_supply rs
1195: , rcv_shipment_headers rsh
1196: , rcv_shipment_lines rsl
1197: , po_lines pol

Line 1380: --Populate the rcv_transactions_rec record with the quantities and UOMs

1376: END IF;
1377:
1378: l_progress := 50;
1379:
1380: --Populate the rcv_transactions_rec record with the quantities and UOMs
1381: --This is later populated with other values from the parent transaction and MMTT
1382: l_rcv_transaction_rec.transaction_quantity := l_um_transfer_qty;
1383: l_rcv_transaction_rec.transaction_uom := l_transfer_uom;
1384: l_rcv_transaction_rec.primary_quantity := l_primary_qty;

Line 1628: FROM rcv_transactions rt

1624: , rt.secondary_unit_of_measure secondary_uom --OPM Convergence
1625: --The following columns are needed for matching in cases where no LPN is involved
1626: , rs.to_subinventory from_subinventory_code
1627: , rs.to_locator_id from_locator_id
1628: FROM rcv_transactions rt
1629: , rcv_supply rs
1630: , rcv_shipment_headers rsh
1631: , rcv_shipment_lines rsl
1632: , mtl_system_items msi

Line 1804: --Populate the rcv_transactions_rec record with the quantities and UOMs

1800: END IF;
1801:
1802: l_progress := 50;
1803:
1804: --Populate the rcv_transactions_rec record with the quantities and UOMs
1805: --This is later populated with other values from the parent transaction and MMTT
1806: l_rcv_transaction_rec.transaction_quantity := l_um_transfer_qty;
1807: l_rcv_transaction_rec.transaction_uom := l_transfer_uom;
1808: l_rcv_transaction_rec.primary_quantity := l_primary_qty;

Line 2044: FROM rcv_transactions rt

2040: , rt.secondary_unit_of_measure secondary_uom --OPM Convergence
2041: --The following columns are needed for matching in cases where no LPN is involved
2042: , rs.to_subinventory from_subinventory_code
2043: , rs.to_locator_id from_locator_id
2044: FROM rcv_transactions rt
2045: , rcv_supply rs
2046: , rcv_shipment_headers rsh
2047: , rcv_shipment_lines rsl
2048: , mtl_system_items msi

Line 2220: --Populate the rcv_transactions_rec record with the quantities and UOMs

2216: print_debug('create_rma_transfer_rec: Quantity to transfer (txn uom): ' || l_um_transfer_qty, 4);
2217: print_debug('Primary Quantity: ' || l_primary_qty ||' Secondary Quantity: ' || l_sec_um_xfer_qty || ' ' || l_secondary_uom_code, 4);
2218: END IF;
2219:
2220: --Populate the rcv_transactions_rec record with the quantities and UOMs
2221: l_rcv_transaction_rec.transaction_quantity := l_um_transfer_qty;
2222: l_rcv_transaction_rec.transaction_uom := l_transfer_uom;
2223: l_rcv_transaction_rec.primary_quantity := l_primary_qty;
2224: l_rcv_transaction_rec.primary_uom := l_primary_uom;

Line 2316: * This procedure creates a RCV_TRANSACTIONS_INTERFACE record for a Receiving

2312:
2313: /*------------------------------------------------------------------------------
2314: * PROCEDURE: create_transfer_rcvtxn_rec
2315: * Description:
2316: * This procedure creates a RCV_TRANSACTIONS_INTERFACE record for a Receiving
2317: * Transfer Transaction
2318: * Called from the Mobile putaway UI and packing workbench
2319: *
2320: * Output Parameters

Line 2962: rcv_transactions rt,

2958: ,rs.secondary_quantity secondary_quantity
2959: ,msni.transaction_interface_id transaction_interface_id
2960: ,rsl.asn_line_flag asn_line_flag
2961: FROM rcv_supply rs,
2962: rcv_transactions rt,
2963: rcv_serials_supply rss,
2964: rcv_shipment_lines rsl,
2965: rcv_shipment_headers rsh,
2966: mtl_serial_numbers_interface msni

Line 3009: rcv_transactions rt,

3005: ,decode(rt.uom_code, p_transfer_uom_code, 1, 2) ORDERING1
3006: ,decode(rt.uom_code, p_transfer_uom_code, (p_transfer_quantity - rs.quantity), 0) ORDERING2
3007: ,rsl.asn_line_flag asn_line_flag
3008: FROM rcv_supply rs,
3009: rcv_transactions rt,
3010: rcv_shipment_lines rsl,
3011: rcv_lots_supply rls,
3012: rcv_shipment_headers rsh
3013: WHERE rs.item_id = p_item_id

Line 3214: FROM rcv_transactions_interface

3210: FROM mtl_transaction_lots_interface
3211: WHERE product_code = 'RCV'
3212: AND product_transaction_id
3213: IN (SELECT interface_transaction_id
3214: FROM rcv_transactions_interface
3215: WHERE parent_transaction_id = l_rtv_rec.rcv_transaction_id
3216: )
3217: AND lot_number = p_lot_number;
3218: EXCEPTION

Line 3279: SELECT rcv_transactions_interface_s.NEXTVAL

3275: GOTO nextrtrecord;
3276: END IF;
3277:
3278:
3279: SELECT rcv_transactions_interface_s.NEXTVAL
3280: INTO l_new_intf_id
3281: FROM dual;
3282:
3283: IF (l_avail_prim_qty < l_remaining_prim_qty ) THEN

Line 3579: SELECT rcv_transactions_interface_s.NEXTVAL

3575: l_rti_tb(l_txn_id)(l_lot_num).quantity
3576: := l_rti_tb(l_txn_id)(l_lot_num).quantity + 1;
3577:
3578: ELSE
3579: SELECT rcv_transactions_interface_s.NEXTVAL
3580: INTO l_new_intf_id
3581: FROM dual;
3582:
3583: l_rti_tb(l_txn_id)(l_lot_num).rti_id := l_new_intf_id;