APPS.RCV_PROCESSOR_PVT dependencies on RCV_SHIPMENT_LINES

Line 77: FROM rcv_shipment_lines rsl

73: FROM rcv_lots_supply rls
74: WHERE rls.lot_num = l_lot_num
75: AND rls.supply_type_code = 'SHIPMENT'
76: AND EXISTS(SELECT 1
77: FROM rcv_shipment_lines rsl
78: WHERE rsl.shipment_header_id = l_shipment_header_id
79: AND rsl.item_id = l_item_id
80: AND rsl.shipment_line_id = rls.shipment_line_id);
81:

Line 261: FROM rcv_shipment_lines

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

Line 608: FROM rcv_shipment_lines

604: SELECT shipment_header_id,
605: item_id
606: INTO l_shipment_header_id,
607: l_item_id
608: FROM rcv_shipment_lines
609: WHERE shipment_line_id = p_shipment_line_id;
610:
611: /* Bug 3376348.
612: * It might happen that the original shipment lines are split

Line 629: FROM rcv_shipment_lines rsl

625: l_serial_suffix_length,
626: '0'
627: )))
628: AND EXISTS(SELECT 1
629: FROM rcv_shipment_lines rsl
630: WHERE rsl.shipment_header_id = l_shipment_header_id
631: AND rsl.shipment_line_id = rss.shipment_line_id
632: AND rsl.item_id = l_item_id);
633: END IF;

Line 859: FROM rcv_shipment_lines rsl

855: FROM rcv_lots_supply rls
856: WHERE rls.lot_num = l_lot_num
857: AND rls.supply_type_code = 'SHIPMENT'
858: AND EXISTS(SELECT 1
859: FROM rcv_shipment_lines rsl
860: WHERE rsl.shipment_header_id = l_shipment_header_id
861: AND rsl.item_id = l_item_id
862: AND rsl.shipment_line_id = rls.shipment_line_id);
863:

Line 1201: FROM rcv_shipment_lines

1197: END IF;
1198:
1199: SELECT unit_of_measure
1200: INTO l_parent_uom
1201: FROM rcv_shipment_lines
1202: WHERE shipment_line_id = l_ship_line_id;
1203:
1204: IF (g_asn_debug = 'Y') THEN
1205: asn_debug.put_line('l_parent_uom ' || l_parent_uom);

Line 1263: from rcv_shipment_lines

1259: END IF;
1260: /*
1261: select shipment_header_id,item_id
1262: into l_shipment_header_id,l_item_id
1263: from rcv_shipment_lines
1264: where shipment_line_id = p_shipment_line_id;
1265:
1266: update rcv_lots_supply rls
1267: set rls.quantity =

Line 1284: AND exists (select 1 from rcv_shipment_lines rsl

1280: p_interface_transaction_id
1281: and mtlt.product_code = 'RCV'
1282: and rls.lot_num = mtlt.lot_number)
1283: where supply_type_code = 'SHIPMENT'
1284: AND exists (select 1 from rcv_shipment_lines rsl
1285: where rsl.shipment_header_id = l_shipment_header_id
1286: and rsl.shipment_line_id = rls.shipment_line_id
1287: and rsl.item_id = l_item_id)
1288: and rls.lot_num = l_lot_num;

Line 1627: FROM rcv_shipment_lines

1623: SELECT shipment_header_id,
1624: item_id
1625: INTO l_shipment_header_id,
1626: l_item_id
1627: FROM rcv_shipment_lines
1628: WHERE shipment_line_id = p_shipment_line_id;
1629:
1630: /* Bug 3376348.
1631: * It might happen that the original shipment lines are split

Line 1648: FROM rcv_shipment_lines rsl

1644: l_serial_suffix_length,
1645: '0'
1646: )))
1647: AND EXISTS(SELECT 1
1648: FROM rcv_shipment_lines rsl
1649: WHERE rsl.shipment_header_id = l_shipment_header_id
1650: AND rsl.shipment_line_id = rss.shipment_line_id
1651: AND rsl.item_id = l_item_id);
1652: