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_PVT5 dependencies on PER_PEOPLE_F

Line 209: po_vendor_sites_all pvs, per_people_f ppf

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
209: po_vendor_sites_all pvs, per_people_f ppf
210: where rti.interface_transaction_id = p_transaction_id
211: AND rti.po_header_id = pha.po_header_id(+)
212: AND rsh.shipment_header_id(+) = rti.shipment_header_id
213: AND pol.po_line_id(+) = rti.po_line_id --Added outer join, bug 4918726

Line 241: po_vendor_sites_all pvs, per_people_f ppf

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
241: po_vendor_sites_all pvs, per_people_f ppf
242: where rti.interface_transaction_id = p_transaction_id
243: AND rti.po_header_id = pha.po_header_id(+)
244: AND rsh.shipment_header_id(+) = rti.shipment_header_id
245: AND pol.po_line_id (+) = rti.po_line_id

Line 433: , per_people_f ppf

429: -- , hr_locations_all hrl1
430: -- , hr_locations_all hrl2
431: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
432: , po_vendor_sites_all pvs
433: , per_people_f ppf
434: , wms_license_plate_numbers wlpn -- Bug 3836623
435: WHERE pha.po_header_id(+) = all_lpn.po_header_id
436: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
437: AND rsh.shipment_header_id = rsl.shipment_header_id

Line 684: , per_people_f ppf

680: , hr_locations_all hrl1
681: , hr_locations_all hrl2
682: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
683: , po_vendor_sites_all pvs
684: , per_people_f ppf
685: WHERE pha.po_header_id(+) = all_lpn.po_header_id
686: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
687: AND pol.po_line_id (+) = all_lpn.po_line_id
688: AND pol.po_header_id (+) = all_lpn.po_header_id

Line 990: , per_people_f ppf

986: , mcch.cycle_count_header_name
987: , ppf.full_name requestor
988: FROM mtl_cycle_count_headers mcch
989: , mtl_cycle_count_entries mcce
990: , per_people_f ppf
991: WHERE mcce.cycle_count_entry_id = p_transaction_Id
992: AND ppf.person_id(+) = mcce.counted_by_employee_id_current
993: AND mcce.cycle_count_header_id=mcch.cycle_count_header_id;
994:

Line 1004: , per_people_f ppf

1000: SELECT mcch.cycle_count_header_name
1001: , ppf.full_name requestor
1002: FROM mtl_cycle_count_headers mcch
1003: , mtl_cycle_count_entries mcce
1004: , per_people_f ppf
1005: , mtl_material_transactions_temp mmtt
1006: WHERE mmtt.transaction_temp_id= p_transaction_id
1007: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id
1008: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id

Line 1263: l_requestor per_people_f.FULL_NAME%TYPE;

1259:
1260: -- Increased this variable size to the corresponding column size in the table.
1261: l_supplier_name po_vendors.VENDOR_NAME%TYPE;
1262: l_supplier_site po_vendor_sites.VENDOR_SITE_CODE%TYPE;
1263: l_requestor per_people_f.FULL_NAME%TYPE;
1264: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;
1265: l_location_code hr_locations_all.LOCATION_CODE%TYPE;
1266: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;
1267: