APPS.WMS_PUTAWAY_UTILS dependencies on RCV_TRANSACTIONS_INTERFACE

Line 8117: SELECT rcv_transactions_interface_s.NEXTVAL

8113: l_progress := '6';
8114:
8115: END IF; --IF (p_first_time = 1)
8116:
8117: SELECT rcv_transactions_interface_s.NEXTVAL
8118: INTO l_interface_transaction_id
8119: FROM dual;
8120:
8121: -- init_start_values should have called gen_txn_group_id

Line 8304: rcv_transactions_interface

8300: ,p_org_id => l_operating_unit_id --
8301: );
8302:
8303: UPDATE
8304: rcv_transactions_interface
8305: SET
8306: validation_flag = 'Y'
8307: ,lpn_group_id = l_group_id
8308: WHERE ROWID = l_rowid;

Line 11439: SELECT rcv_transactions_interface_s.NEXTVAL

11435: --ramarava
11436: --Commenting the below portion coz as a part of change in 10262461 we decided to ask for Serial Validation even for qty 1
11437: --This was done as in cases of item based putaway of serial items putaway was failing due to mismatched l_product_transaction_id value.
11438: /*IF (l_serialized_item AND l_mmtt_prm_qty = 1) THEN
11439: SELECT rcv_transactions_interface_s.NEXTVAL
11440: INTO l_product_transaction_id
11441: FROM sys.dual;
11442: END IF;
11443: */

Line 12727: FROM rcv_transactions_interface rti, mtl_material_transactions_temp mmtt

12723: SELECT MAX(mtrl.backorder_delivery_detail_id)
12724: INTO l_bo_d_to_id
12725: FROM mtl_txn_request_lines mtrl
12726: WHERE EXISTS (SELECT 1
12727: FROM rcv_transactions_interface rti, mtl_material_transactions_temp mmtt
12728: WHERE rti.transfer_lpn_id = l_into_lpn_id
12729: AND rti.mmtt_temp_id = mmtt.transaction_temp_id
12730: AND mmtt.move_order_line_id = mtrl.line_id
12731: AND mmtt.inventory_item_id = mtrl.inventory_item_id

Line 13694: DELETE FROM rcv_transactions_interface

13690: CONNECT BY PRIOR lpn_id = parent_lpn_id
13691: );
13692:
13693: -- bug:15926098
13694: DELETE FROM rcv_transactions_interface
13695: WHERE lpn_id IN ( p_lpn_id )
13696: OR transfer_lpn_id IN ( p_lpn_id )
13697: AND from_organization_id = l_org_id
13698: AND transaction_type <> 'SHIP'

Line 13900: rcv_transactions_interface

13896: (
13897: SELECT
13898: interface_transaction_id
13899: FROM
13900: rcv_transactions_interface
13901: WHERE
13902: lpn_id IN (p_lpn_id)
13903: OR transfer_lpn_id IN (p_lpn_id)
13904: );

Line 13915: rcv_transactions_interface

13911: (
13912: SELECT
13913: interface_transaction_id
13914: FROM
13915: rcv_transactions_interface
13916: WHERE
13917: lpn_id IN (p_lpn_id)
13918: OR transfer_lpn_id IN (p_lpn_id)
13919: );

Line 14025: rcv_transactions_interface

14021: (
14022: SELECT
14023: interface_transaction_id
14024: FROM
14025: rcv_transactions_interface
14026: WHERE
14027: lpn_id IN (p_lpn_id)
14028: OR transfer_lpn_id IN (p_lpn_id)
14029: );

Line 14103: rcv_transactions_interface

14099:
14100: --Skipping RTI of transaction type 'SHIP'
14101: DELETE
14102: FROM
14103: rcv_transactions_interface
14104: WHERE
14105: lpn_id IN (p_lpn_id)
14106: OR transfer_lpn_id IN (p_lpn_id)
14107: AND from_organization_id = l_org_id