APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on RCV_TRANSACTIONS_INTERFACE

Line 1635: l_dest_subinventory rcv_transactions_interface.subinventory%TYPE;

1631: IS
1632:
1633: l_api_name VARCHAR2(50) := 'process_rcv_interface';
1634: l_routing_header_id PO_LINE_LOCATIONS_ALL.Receiving_Routing_Id%TYPE;
1635: l_dest_subinventory rcv_transactions_interface.subinventory%TYPE;
1636: l_dest_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1637: l_default_locator_id wip_parameters.default_pull_supply_locator_id%TYPE;
1638: l_locator_type MTL_SECONDARY_INVENTORIES.locator_type%TYPE;
1639: l_project_id OE_ORDER_LINES_ALL.project_id%TYPE;

Line 1680: from rcv_transactions_interface rti

1676: AND not exists (select 1
1677: from rcv_transactions rt
1678: where REPLENISH_ORDER_LINE_ID = oola.line_id)
1679: AND not exists (select 1
1680: from rcv_transactions_interface rti
1681: where REPLENISH_ORDER_LINE_ID = oola.line_id
1682: and TRANSACTION_STATUS_CODE <> 'ERROR'
1683: AND PROCESSING_STATUS_CODE <> 'ERROR')
1684: ORDER BY d.distribution_num; --If multiple Replenishment PO Distributions exist then handle in their order.

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

2213: -- end debug log\
2214:
2215: IF l_routing_header_id = 1 OR l_routing_header_id = 2
2216: THEN
2217: -- process rcv trx, insert transactions data into rcv_transactions_interface
2218: JMF_SHIKYU_RCV_PVT.process_rcv_trx(p_rcv_header_id => l_rcv_header_id
2219: , p_group_id => l_group_id
2220: , p_quantity => l_insert_quantity
2221: , p_unit_of_measure => l_so_uom

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

2230: , p_replenish_order_line_id => p_lines_id(l_index)
2231: );
2232: ELSIF l_routing_header_id = 3
2233: THEN
2234: -- process rcv trx, insert transactions data into rcv_transactions_interface
2235: JMF_SHIKYU_RCV_PVT.process_rcv_trx(p_rcv_header_id => l_rcv_header_id
2236: , p_group_id => l_group_id
2237: , p_quantity => l_insert_quantity
2238: , p_unit_of_measure => l_so_uom