APPS.INV_3PL_SEEDED_SOURCES dependencies on RCV_SHIPMENT_LINES

Line 94: from rcv_transactions rt , rcv_shipment_lines rsl

90: debug('recs.l_source_to_date => '|| To_Char(l_source_to_date, 'DD-MON-YYYY HH24:MI:SS'));
91: debug('recs.l_last_computation_date => '|| To_Char(l_last_computation_date, 'DD-MON-YYYY HH24:MI:SS'));
92:
93: Select count(1) INTO l_temp
94: from rcv_transactions rt , rcv_shipment_lines rsl
95: WHERE rsl.shipment_line_id = rt.shipment_line_id
96: and rt.shipment_header_id = rt.shipment_header_id
97: AND rsl.item_id = recs.inventory_item_id
98: AND rt.creation_date <= l_source_to_date

Line 323: from rcv_transactions rt, rcv_shipment_lines rsl

319: -- Bug 9475436 --
320:
321: Cursor rt_record(p_inventory_item_id NUMBER , p_source_to_date DATE,p_last_computation_Date DATE, p_organization_id NUMBER) IS
322: Select rt.quantity quantity, NVL(rt.uom_code, get_item_uom_code(rt.unit_of_measure)) from_uom_code , rsl.item_id
323: from rcv_transactions rt, rcv_shipment_lines rsl
324: WHERE rsl.shipment_line_id = rt.shipment_line_id
325: and rt.shipment_header_id = rt.shipment_header_id
326: AND rsl.item_id = p_inventory_item_id
327: AND rt.creation_date <= p_source_to_date

Line 490: from rcv_transactions rt, rcv_shipment_lines rsl

486: debug('recs.l_source_to_date => '|| To_Char(l_source_to_date, 'DD-MON-YYYY HH24:MI:SS'));
487: debug('recs.l_last_computation_date => '|| To_Char(l_last_computation_date, 'DD-MON-YYYY HH24:MI:SS'));
488:
489: Select count(*) INTO l_temp
490: from rcv_transactions rt, rcv_shipment_lines rsl
491: WHERE rsl.shipment_line_id = rt.shipment_line_id
492: and rt.shipment_header_id = rt.shipment_header_id
493: AND rsl.item_id = recs.inventory_item_id
494: AND rt.creation_date <= l_source_to_date