APPS.RCV_PROCESSOR_PVT dependencies on RCV_SHIPMENT_LINES

Line 262: FROM rcv_shipment_lines

258: END IF;
259:
260: SELECT unit_of_measure
261: INTO l_parent_uom
262: FROM rcv_shipment_lines
263: WHERE shipment_line_id = l_ship_line_id;
264:
265: IF (g_asn_debug = 'Y') THEN
266: asn_debug.put_line('l_parent_uom ' || l_parent_uom);

Line 621: FROM rcv_shipment_lines

617: SELECT shipment_header_id,
618: item_id
619: INTO l_shipment_header_id,
620: l_item_id
621: FROM rcv_shipment_lines
622: WHERE shipment_line_id = p_shipment_line_id;
623:
624: /* Bug 3376348.
625: * It might happen that the original shipment lines are split

Line 642: FROM rcv_shipment_lines rsl

638: l_serial_suffix_length,
639: '0'
640: )))
641: AND EXISTS(SELECT 1
642: FROM rcv_shipment_lines rsl
643: WHERE rsl.shipment_header_id = l_shipment_header_id
644: AND rsl.shipment_line_id = rss.shipment_line_id
645: AND rsl.item_id = l_item_id);
646: END IF;

Line 1205: FROM rcv_shipment_lines

1201: END IF;
1202:
1203: SELECT unit_of_measure
1204: INTO l_parent_uom
1205: FROM rcv_shipment_lines
1206: WHERE shipment_line_id = l_ship_line_id;
1207:
1208: IF (g_asn_debug = 'Y') THEN
1209: asn_debug.put_line('l_parent_uom ' || l_parent_uom);

Line 1276: from rcv_shipment_lines

1272: END IF; --Bug 7443786
1273: /*
1274: select shipment_header_id,item_id
1275: into l_shipment_header_id,l_item_id
1276: from rcv_shipment_lines
1277: where shipment_line_id = p_shipment_line_id;
1278:
1279: update rcv_lots_supply rls
1280: set rls.quantity =

Line 1297: AND exists (select 1 from rcv_shipment_lines rsl

1293: p_interface_transaction_id
1294: and mtlt.product_code = 'RCV'
1295: and rls.lot_num = mtlt.lot_number)
1296: where supply_type_code = 'SHIPMENT'
1297: AND exists (select 1 from rcv_shipment_lines rsl
1298: where rsl.shipment_header_id = l_shipment_header_id
1299: and rsl.shipment_line_id = rls.shipment_line_id
1300: and rsl.item_id = l_item_id)
1301: and rls.lot_num = l_lot_num;

Line 1640: FROM rcv_shipment_lines

1636: SELECT shipment_header_id,
1637: item_id
1638: INTO l_shipment_header_id,
1639: l_item_id
1640: FROM rcv_shipment_lines
1641: WHERE shipment_line_id = p_shipment_line_id;
1642:
1643: /* Bug 3376348.
1644: * It might happen that the original shipment lines are split

Line 1661: FROM rcv_shipment_lines rsl

1657: l_serial_suffix_length,
1658: '0'
1659: )))
1660: AND EXISTS(SELECT 1
1661: FROM rcv_shipment_lines rsl
1662: WHERE rsl.shipment_header_id = l_shipment_header_id
1663: AND rsl.shipment_line_id = rss.shipment_line_id
1664: AND rsl.item_id = l_item_id);
1665: