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

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

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