[Home] [Help]
134: pov.vendor_name supplier_name, pvs.vendor_site_id vendor_site_id,
135: pvs.vendor_site_code supplier_site, ppf.full_name requestor,
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
166: pov.vendor_name supplier_name, pvs.vendor_site_id vendor_site_id,
167: pvs.vendor_site_code supplier_site, ppf.full_name requestor,
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
231: , rt.quantity
232: , project_id -- bug 8430171
233: , task_id -- bug 8430171
234: , rt.shipment_line_id --- 15918971
235: from rcv_transactions rt
236: where rt.lpn_id is not null
237: and rt.group_id = p_transaction_id
238: AND ((rt.transaction_type IN ('ACCEPT', 'REJECT')
239: AND p_label_type_info.business_flow_code = 2)
257: , rt.project_id -- bug 8430171
258: , rt.task_id -- bug 8430171
259: , rt.shipment_line_id --- 15918971
260: from wms_license_plate_numbers lpn,
261: rcv_transactions rt
262: where lpn.lpn_id = rt.lpn_id
263: and lpn.parent_lpn_id <> rt.lpn_id
264: and rt.group_id = p_transaction_id
265: and lpn.parent_lpn_id is not null -- parentLPN could be null for single-level LPN
284: , rt.quantity
285: , rt.project_id -- bug 8430171
286: , rt.task_id -- bug 8430171
287: , rt.shipment_line_id --- 15918971
288: from wms_license_plate_numbers lpn, rcv_transactions rt
289: where lpn.lpn_id = rt.lpn_id
290: and lpn.outermost_lpn_id <> lpn.lpn_id
291: and lpn.outermost_lpn_id <> lpn.parent_lpn_id
292: and rt.group_id = p_transaction_id
311: , rt.quantity
312: , project_id -- bug 8430171
313: , task_id -- bug 8430171
314: , rt.shipment_line_id --- 15918971
315: from rcv_transactions rt
316: where
317: nvl(transfer_lpn_id,-999) <> nvl(lpn_id,-999) AND
318: group_id = p_transaction_id
319: AND ((rt.transaction_type IN ('ACCEPT', 'REJECT')
337: , rt.quantity
338: , rt.project_id -- bug 8430171
339: , rt.task_id -- bug 8430171
340: , rt.shipment_line_id --- 15918971
341: from wms_license_plate_numbers lpn, rcv_transactions rt
342: where lpn.lpn_id = rt.transfer_lpn_id
343: and rt.transfer_lpn_id <> rt.lpn_id
344: and lpn.parent_lpn_id <> lpn.lpn_id
345: and lpn.parent_lpn_id is not null -- parentLPN could be null for single-level LPN
365: , rt.quantity
366: , rt.project_id -- bug 8430171
367: , rt.task_id -- bug 8430171
368: , rt.shipment_line_id --- 15918971
369: from wms_license_plate_numbers lpn, rcv_transactions rt
370: where lpn.lpn_id = rt.transfer_lpn_id
371: and rt.transfer_lpn_id <> rt.lpn_id
372: and lpn.outermost_lpn_id <> lpn.lpn_id
373: and lpn.outermost_lpn_id <> lpn.parent_lpn_id
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
1375: and rt.transfer_lpn_id = p_lpn_id