[Home] [Help]
200: pov.vendor_id vendor_id, pov.vendor_name supplier_name,
201: pvs.vendor_site_id vendor_site_id, pvs.vendor_site_code supplier_site,
202: ppf.full_name requestor, hrl1.location_code deliver_to_location,
203: hrl2.location_code location, pll.note_to_receiver note_to_receiver
204: FROM rcv_transactions_interface rti, po_headers_all pha,
205: -- MOAC : changed po_line_locations to po_line_locations_all
206: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
207: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
208: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
232: pvs.vendor_site_id vendor_site_id,
233: pvs.vendor_site_code supplier_site, ppf.full_name requestor,
234: hrl1.location_code deliver_to_location, hrl2.location_code location,
235: pll.note_to_receiver note_to_receiver
236: FROM rcv_transactions_interface rti, po_headers_all pha,
237: -- MOAC : changed po_line_locations to po_line_locations_all
238: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
239: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
240: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
289: , shipment_header_id, po_line_location_id
290: , vendor_id, vendor_site_id
291: , deliver_to_person_id, deliver_to_location_id
292: , location_id
293: from rcv_transactions rt
294: where rt.lpn_id is not null
295: and rt.group_id = p_transaction_id
296: AND ((rt.transaction_type IN ('ACCEPT', 'REJECT')
297: AND p_label_type_info.business_flow_code = 2)
311: , rt.vendor_id, rt.vendor_site_id
312: , rt.deliver_to_person_id, rt.deliver_to_location_id deliver_to_location_id
313: , rt.location_id location_id
314: from wms_license_plate_numbers lpn,
315: rcv_transactions rt
316: where lpn.lpn_id = rt.lpn_id
317: and lpn.parent_lpn_id <> rt.lpn_id
318: and lpn.parent_lpn_id is not null
319: and rt.group_id = p_transaction_id
334: , rt.shipment_header_id, rt.po_line_location_id
335: , rt.vendor_id, rt.vendor_site_id
336: , rt.deliver_to_person_id, rt.deliver_to_location_id deliver_to_location_id
337: , rt.location_id location_id
338: from wms_license_plate_numbers lpn, rcv_transactions rt
339: where lpn.lpn_id = rt.lpn_id
340: and lpn.outermost_lpn_id <> lpn.lpn_id
341: and lpn.outermost_lpn_id <> lpn.parent_lpn_id
342: and rt.group_id = p_transaction_id
357: , shipment_header_id, po_line_location_id
358: , vendor_id, vendor_site_id
359: , deliver_to_person_id, deliver_to_location_id
360: , location_id
361: from rcv_transactions rt
362: where nvl(transfer_lpn_id,-999) <> nvl(lpn_id,-999)
363: and group_id = p_transaction_id
364: AND ((rt.transaction_type IN ('ACCEPT', 'REJECT')
365: AND p_label_type_info.business_flow_code = 2)
378: , rt.shipment_header_id, rt.po_line_location_id
379: , rt.vendor_id, rt.vendor_site_id
380: , rt.deliver_to_person_id, rt.deliver_to_location_id deliver_to_location_id
381: , rt.location_id location_id
382: from wms_license_plate_numbers lpn, rcv_transactions rt
383: where lpn.lpn_id = rt.transfer_lpn_id
384: and rt.transfer_lpn_id <> rt.lpn_id
385: and lpn.parent_lpn_id is not null
386: and lpn.parent_lpn_id <> lpn.lpn_id
402: , rt.shipment_header_id, rt.po_line_location_id
403: , rt.vendor_id, rt.vendor_site_id
404: , rt.deliver_to_person_id, rt.deliver_to_location_id deliver_to_location_id
405: , rt.location_id location_id
406: from wms_license_plate_numbers lpn, rcv_transactions rt
407: where lpn.lpn_id = rt.transfer_lpn_id
408: and rt.transfer_lpn_id <> rt.lpn_id
409: and lpn.outermost_lpn_id <> lpn.lpn_id
410: and lpn.outermost_lpn_id <> lpn.parent_lpn_id