[Home] [Help]
136: hrl1.location_code deliver_to_location,
137: hrl2.location_code location, pll.note_to_receiver note_to_receiver
138: FROM rcv_transactions_interface rti, po_headers_trx_v pha,--CLM Changes, using CLM views instead of base tables
139: -- MOAC : po_line_locations changed to po_line_locations_all
140: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,
141: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
142: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
143: po_vendor_sites_all pvs, per_people_f ppf
144: where rti.interface_transaction_id = p_transaction_id
168: hrl1.location_code deliver_to_location,
169: hrl2.location_code location, pll.note_to_receiver note_to_receiver
170: FROM rcv_transactions_interface rti, po_headers_trx_v pha,--CLM Changes,using CLM views instead of base tables
171: -- MOAC : po_line_locations changed to po_line_locations_all
172: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,
173: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
174: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
175: po_vendor_sites_all pvs, per_people_f ppf
176: where rti.interface_transaction_id = p_transaction_id
383: )
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
1117: rsl.COUNTRY_OF_ORIGIN_CODE ,
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
1146: rsl.COUNTRY_OF_ORIGIN_CODE ,
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
1177: rsl.COUNTRY_OF_ORIGIN_CODE ,
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
1191: ) all_lpn ,
1192: po_headers_trx_v pha--CLM Changes, using CLM views instead of base tables
1193: ,
1194: po_lines_trx_v pol ,
1195: rcv_shipment_headers rsh
1196: -- MOAC : po_line_locations changed to po_line_locations_all
1197: ,
1198: po_line_locations_trx_v pll ,
1199: po_vendors pov ,
1366:
1367: -- 14225761 start
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
1785: l_rcv_isp_header.bill_of_lading, l_rcv_isp_header.waybill_airbill_num,
1786: l_rcv_isp_header.packing_slip,
1787: l_rcv_isp_header.packaging_code, l_rcv_isp_header.special_handling_code,
1788: l_rcv_isp_header.receipt_num,l_rcv_isp_header.comments
1789: FROM rcv_shipment_headers
1790: WHERE shipment_header_id = p_transaction_id;
1791:
1792: -- Next retrieve details of all distinct LPNs associated with this shipment
1793: FOR v_asn_lpn IN c_asn_lpn