eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_LABEL_PVT1 dependencies on PO_LINE_LOCATIONS

Line 309: -- MOAC: Replaced the po_line_locations

305: -- Putaway no apply for Inv org
306: -- Delivery rti rti+mtlt rti or mtlt
307: -- Therefore, two cursors are needed, rti+lpnContent or rti+mtlt
308:
309: -- MOAC: Replaced the po_line_locations
310: -- view with a _ALL table the where clause of
311: -- the cursor select is sufficient to stripe
312: -- by a single OU.
313:

Line 365: , po_line_locations_all pll

361: , wms_lpn_contents wlc
362: , po_lines_all pol
363: , po_headers_all pha
364: , rcv_shipment_headers rsh
365: , po_line_locations_all pll
366: , po_vendors pov
367: , hr_locations_all hrl1
368: , hr_locations_all hrl2
369: , po_vendor_sites_all pvs

Line 391: -- MOAC: Replaced the po_line_locations

387: AND rti.interface_transaction_id = p_transaction_id
388: AND wojv.wip_entity_id = rti.wip_entity_id
389: AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date(+) AND ppf.effective_end_date(+); -- for bug#5889715
390:
391: -- MOAC: Replaced the po_line_locations
392: -- view with a _ALL table the where clause of
393: -- the cursor select is sufficient to stripe
394: -- by a single OU.
395:

Line 447: , po_line_locations_all pll

443: , wms_lpn_contents wlc
444: , po_lines_all pol
445: , po_headers_all pha
446: , rcv_shipment_headers rsh
447: , po_line_locations_all pll
448: , po_vendors pov
449: , hr_locations_all hrl1
450: , hr_locations_all hrl2
451: , po_vendor_sites_all pvs

Line 476: -- MOAC: Replaced the po_line_locations

472: -- RTI + MTLT
473: -- This is the new cursor designed for the "I" cleanup project for printing at receipt
474: -- Added vendor_id and vendor_site_id to the cursor for Bug 2748297
475:
476: -- MOAC: Replaced the po_line_locations
477: -- view with a _ALL table the where clause of
478: -- the cursor select is sufficient to stripe
479: -- by a single OU.
480:

Line 547: , po_line_locations_all pll

543: FROM rcv_transactions_interface rti
544: , po_lines_all pol
545: , po_headers_all pha
546: , rcv_shipment_headers rsh
547: , po_line_locations_all pll
548: , po_vendors pov
549: , hr_locations hrl1
550: , hr_locations hrl2
551: -- MOAC changed po_vendor_sites to po_vendor_sites_all

Line 618: -- MOAC: Replaced the po_line_locations

614: * Use one cursor that queries RCV_TRANSACTIONS_INTERFACE and RCV_LOTS_INTERFACE tables for
615: * Item, Lot, Quantity information
616: */
617:
618: -- MOAC: Replaced the po_line_locations
619: -- view with a _ALL table the where clause of
620: -- the cursor select is sufficient to stripe
621: -- by a single OU.
622:

Line 702: , po_line_locations_all pll

698: , po_lines_all pol
699: -- , po_distributions_all pod --Commented as part of Bug# 3586116
700: , po_headers_all pha
701: , rcv_shipment_headers rsh
702: , po_line_locations_all pll
703: , po_vendors pov
704: , hr_locations_all hrl1
705: , hr_locations_all hrl2
706: , po_vendor_sites_all pvs

Line 888: , po_line_locations pll

884: , po_lines_all pol
885: -- , po_distributions_all pod --Commented as part of Bug# 3586116
886: , po_headers_all pha
887: , rcv_shipment_headers rsh
888: , po_line_locations pll
889: , po_vendors pov
890: , hr_locations_all hrl1
891: , hr_locations_all hrl2
892: , po_vendor_sites_all pvs

Line 1059: , po_line_locations pll

1055: , po_lines_all pol
1056: -- , po_distributions_all pod --Commented as part of Bug# 3586116
1057: , po_headers_all pha
1058: , rcv_shipment_headers rsh
1059: , po_line_locations pll
1060: , po_vendors pov
1061: , hr_locations_all hrl1
1062: , hr_locations_all hrl2
1063: , po_vendor_sites_all pvs

Line 1988: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;

1984: l_supplier_site po_vendor_sites.VENDOR_SITE_CODE%TYPE;
1985: l_requestor per_people_f.FULL_NAME%TYPE;
1986: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;
1987: l_location_code hr_locations_all.LOCATION_CODE%TYPE;
1988: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;
1989:
1990: -- END of Bug fix for 3916663
1991: l_routing_name VARCHAR2(30);
1992: l_content_rec_index NUMBER := 0;