APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on RCV_TRANSACTIONS_INTERFACE

Line 1615: l_dest_subinventory rcv_transactions_interface.subinventory%TYPE;

1611: IS
1612:
1613: l_api_name VARCHAR2(50) := 'process_rcv_interface';
1614: l_routing_header_id PO_LINE_LOCATIONS_ALL.Receiving_Routing_Id%TYPE;
1615: l_dest_subinventory rcv_transactions_interface.subinventory%TYPE;
1616: l_dest_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1617: l_default_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1618: l_locator_type MTL_SECONDARY_INVENTORIES.locator_type%TYPE;
1619: l_project_id OE_ORDER_LINES_ALL.project_id%TYPE;

Line 1660: from rcv_transactions_interface rti

1656: AND not exists (select 1
1657: from rcv_transactions rt
1658: where REPLENISH_ORDER_LINE_ID = oola.line_id)
1659: AND not exists (select 1
1660: from rcv_transactions_interface rti
1661: where REPLENISH_ORDER_LINE_ID = oola.line_id
1662: and TRANSACTION_STATUS_CODE <> 'ERROR'
1663: AND PROCESSING_STATUS_CODE <> 'ERROR')
1664: ORDER BY d.distribution_num; --If multiple Replenishment PO Distributions exist then handle in their order.

Line 2197: -- process rcv trx, insert transactions data into rcv_transactions_interface

2193: -- end debug log\
2194:
2195: IF l_routing_header_id = 1 OR l_routing_header_id = 2
2196: THEN
2197: -- process rcv trx, insert transactions data into rcv_transactions_interface
2198: JMF_SHIKYU_RCV_PVT.process_rcv_trx(p_rcv_header_id => l_rcv_header_id
2199: , p_group_id => l_group_id
2200: , p_quantity => l_insert_quantity
2201: , p_unit_of_measure => l_so_uom

Line 2214: -- process rcv trx, insert transactions data into rcv_transactions_interface

2210: , p_replenish_order_line_id => p_lines_id(l_index)
2211: );
2212: ELSIF l_routing_header_id = 3
2213: THEN
2214: -- process rcv trx, insert transactions data into rcv_transactions_interface
2215: JMF_SHIKYU_RCV_PVT.process_rcv_trx(p_rcv_header_id => l_rcv_header_id
2216: , p_group_id => l_group_id
2217: , p_quantity => l_insert_quantity
2218: , p_unit_of_measure => l_so_uom