[Home] [Help]
203: pov.vendor_id vendor_id, pov.vendor_name supplier_name,
204: pvs.vendor_site_id vendor_site_id, pvs.vendor_site_code supplier_site,
205: ppf.full_name requestor, hrl1.location_code deliver_to_location,
206: hrl2.location_code location, pll.note_to_receiver note_to_receiver
207: FROM rcv_transactions_interface rti, po_headers_trx_v pha,--CLM Changes,using CLM views instead of base tables
208: -- MOAC : changed po_line_locations to po_line_locations_all
209: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,
210: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
211: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
235: pvs.vendor_site_id vendor_site_id,
236: pvs.vendor_site_code supplier_site, ppf.full_name requestor,
237: hrl1.location_code deliver_to_location, hrl2.location_code location,
238: pll.note_to_receiver note_to_receiver
239: FROM rcv_transactions_interface rti, po_headers_trx_v pha,--CLM Changes,using CLM views instead of base tables
240: -- MOAC : changed po_line_locations to po_line_locations_all
241: po_lines_trx_v pol, rcv_shipment_headers rsh, po_line_locations_trx_v pll,
242: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
243: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
292: , shipment_header_id, po_line_location_id
293: , vendor_id, vendor_site_id
294: , deliver_to_person_id, deliver_to_location_id
295: , location_id
296: from rcv_transactions rt
297: where rt.lpn_id is not null
298: and rt.group_id = p_transaction_id
299: AND ((rt.transaction_type IN ('ACCEPT', 'REJECT')
300: AND p_label_type_info.business_flow_code = 2)
314: , rt.vendor_id, rt.vendor_site_id
315: , rt.deliver_to_person_id, rt.deliver_to_location_id deliver_to_location_id
316: , rt.location_id location_id
317: from wms_license_plate_numbers lpn,
318: rcv_transactions rt
319: where lpn.lpn_id = rt.lpn_id
320: and lpn.parent_lpn_id <> rt.lpn_id
321: and lpn.parent_lpn_id is not null
322: and rt.group_id = p_transaction_id
337: , rt.shipment_header_id, rt.po_line_location_id
338: , rt.vendor_id, rt.vendor_site_id
339: , rt.deliver_to_person_id, rt.deliver_to_location_id deliver_to_location_id
340: , rt.location_id location_id
341: from wms_license_plate_numbers lpn, rcv_transactions rt
342: where lpn.lpn_id = rt.lpn_id
343: and lpn.outermost_lpn_id <> lpn.lpn_id
344: and lpn.outermost_lpn_id <> lpn.parent_lpn_id
345: and rt.group_id = p_transaction_id
360: , shipment_header_id, po_line_location_id
361: , vendor_id, vendor_site_id
362: , deliver_to_person_id, deliver_to_location_id
363: , location_id
364: from rcv_transactions rt
365: where nvl(transfer_lpn_id,-999) <> nvl(lpn_id,-999)
366: and group_id = p_transaction_id
367: AND ((rt.transaction_type IN ('ACCEPT', 'REJECT')
368: AND p_label_type_info.business_flow_code = 2)
381: , rt.shipment_header_id, rt.po_line_location_id
382: , rt.vendor_id, rt.vendor_site_id
383: , rt.deliver_to_person_id, rt.deliver_to_location_id deliver_to_location_id
384: , rt.location_id location_id
385: from wms_license_plate_numbers lpn, rcv_transactions rt
386: where lpn.lpn_id = rt.transfer_lpn_id
387: and rt.transfer_lpn_id <> rt.lpn_id
388: and lpn.parent_lpn_id is not null
389: and lpn.parent_lpn_id <> lpn.lpn_id
405: , rt.shipment_header_id, rt.po_line_location_id
406: , rt.vendor_id, rt.vendor_site_id
407: , rt.deliver_to_person_id, rt.deliver_to_location_id deliver_to_location_id
408: , rt.location_id location_id
409: from wms_license_plate_numbers lpn, rcv_transactions rt
410: where lpn.lpn_id = rt.transfer_lpn_id
411: and rt.transfer_lpn_id <> rt.lpn_id
412: and lpn.outermost_lpn_id <> lpn.lpn_id
413: and lpn.outermost_lpn_id <> lpn.parent_lpn_id