APPS.JMF_SHIKYU_AUTO_RCV_PROC dependencies on RCV_TRANSACTIONS

Line 54: --| RCV transactions. |

50: --| is 'Closed' to fix #5231430 |
51: --| 08-Jun-2006 THE2 correct the hard code of operation unit |
52: --| 15-JUN-2006 THE2 Add locator_id process logic |
53: --| 27-JUN-2006 THE2 Removed the logic for checking duplicated |
54: --| RCV transactions. |
55: --| 28-JUN-2006 THE2 Met the interface change of procedure |
56: --| jmf_shikyu_util.Get_Replenish_So_Returned_Qty|
57: --| and JMF_SHIKYU_RCV_PVT.process_rcv_trx |
58: --| 03-AUG-2006 THE2 Modified cursor po_distributions_c to fix |

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 1657: from rcv_transactions rt

1653: AND l.line_location_id = d.line_location_id
1654: AND oola.order_quantity_uom = uom.uom_code(+)
1655: and oola.line_id = p_line_id
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

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