APPS.INV_LABEL_PVT4 dependencies on RCV_SHIPMENT_LINES

Line 388: , rcv_shipment_lines rsl

384: ) all_lpn
385: , po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
386: , po_lines_trx_v pol
387: , rcv_shipment_headers rsh
388: , rcv_shipment_lines rsl
389: -- MOAC : po_line_locations changed to po_line_locations_all
390: , po_line_locations_trx_v pll
391: , po_vendors pov
392: -- , hr_locations_all hrl1

Line 1122: rcv_shipment_lines rsl

1118: rsl.comments ,
1119: rsl.vendor_item_num
1120: FROM wms_license_plate_numbers lpn,
1121: rcv_shipment_headers rsh,
1122: rcv_shipment_lines rsl
1123: WHERE lpn.source_name = rsh.shipment_num
1124: AND lpn.lpn_context = 7
1125: AND rsl.shipment_header_id = rsh.shipment_header_id
1126: AND rsh.shipment_header_id = p_transaction_id

Line 1151: rcv_shipment_lines rsl

1147: rsl.comments ,
1148: rsl.vendor_item_num
1149: FROM wms_license_plate_numbers lpn,
1150: rcv_shipment_headers rsh,
1151: rcv_shipment_lines rsl
1152: WHERE lpn.source_name = rsh.shipment_num
1153: AND lpn.lpn_context = 7
1154: AND rsl.shipment_header_id = rsh.shipment_header_id
1155: AND rsl.asn_lpn_id = lpn.lpn_id

Line 1182: rcv_shipment_lines rsl

1178: rsl.comments ,
1179: rsl.vendor_item_num
1180: FROM wms_license_plate_numbers lpn,
1181: rcv_shipment_headers rsh,
1182: rcv_shipment_lines rsl
1183: WHERE lpn.source_name = rsh.shipment_num
1184: AND lpn.lpn_context = 7
1185: AND rsl.shipment_header_id = rsh.shipment_header_id
1186: AND rsh.shipment_header_id = p_transaction_id

Line 1372: rcv_shipment_lines rsl

1368: cursor c_fetch_rcpt_num(p_lpn_id number, p_item_id number) is
1369: select rsh.receipt_num
1370: from rcv_shipment_headers rsh,
1371: rcv_transactions rt,
1372: rcv_shipment_lines rsl
1373: where rt.shipment_header_id = rsh.shipment_header_id
1374: and rsl.shipment_header_id = rt.shipment_header_id
1375: and rt.transfer_lpn_id = p_lpn_id
1376: and rsl.item_id = p_item_id