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 PER_PEOPLE_F

Line 370: , per_people_f ppf

366: , po_vendors pov
367: , hr_locations_all hrl1
368: , hr_locations_all hrl2
369: , po_vendor_sites_all pvs
370: , per_people_f ppf
371: , rcv_routing_headers rrh
372: , wip_osp_jobs_val_v wojv
373: WHERE wlc.parent_lpn_id(+) = rti.lpn_id
374: AND wlc.inventory_item_id(+) = rti.item_id -- bug 2372669

Line 452: , per_people_f ppf

448: , po_vendors pov
449: , hr_locations_all hrl1
450: , hr_locations_all hrl2
451: , po_vendor_sites_all pvs
452: , per_people_f ppf
453: , rcv_routing_headers rrh
454: , wip_osp_jobs_val_v wojv
455: WHERE wlc.parent_lpn_id(+) = rti.transfer_lpn_id
456: AND wlc.inventory_item_id(+) = rti.item_id -- bug 2372669

Line 707: , per_people_f ppf

703: , po_vendors pov
704: , hr_locations_all hrl1
705: , hr_locations_all hrl2
706: , po_vendor_sites_all pvs
707: , per_people_f ppf
708: , rcv_routing_headers rrh
709: -- Bug 4516067, to improve performance, query the base table directly
710: --, wip_osp_jobs_val_v wojv
711: , wip_entities we -- Added for Bug#4516067

Line 893: , per_people_f ppf

889: , po_vendors pov
890: , hr_locations_all hrl1
891: , hr_locations_all hrl2
892: , po_vendor_sites_all pvs
893: , per_people_f ppf
894: , rcv_routing_headers rrh
895: -- Bug 4516067, to improve performance, query the base table directly
896: --, wip_osp_jobs_val_v wojv
897: , wip_entities we

Line 1064: , per_people_f ppf

1060: , po_vendors pov
1061: , hr_locations_all hrl1
1062: , hr_locations_all hrl2
1063: , po_vendor_sites_all pvs
1064: , per_people_f ppf
1065: , rcv_routing_headers rrh
1066: -- Bug 4516067, to improve performance, query the base table directly
1067: --, wip_osp_jobs_val_v wojv
1068: , wip_entities we

Line 1922: per_people_f ppf

1918: mcch.cycle_count_header_name,
1919: ppf.full_name requestor
1920: FROM mtl_cycle_count_headers mcch,
1921: mtl_cycle_count_entries mcce,
1922: per_people_f ppf
1923: WHERE mcce.cycle_count_entry_id = p_transaction_Id
1924: AND ppf.person_id(+) = mcce.counted_by_employee_id_current
1925: AND mcce.cycle_count_header_id=mcch.cycle_count_header_id;
1926:

Line 1937: per_people_f ppf,

1933: SELECT mcch.cycle_count_header_name,
1934: ppf.full_name requestor
1935: FROM mtl_cycle_count_headers mcch,
1936: mtl_cycle_count_entries mcce,
1937: per_people_f ppf,
1938: mtl_material_transactions_temp mmtt
1939: WHERE mmtt.transaction_temp_id= p_transaction_id
1940: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id
1941: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id

Line 1985: l_requestor per_people_f.FULL_NAME%TYPE;

1981:
1982: -- Increased this variable size to the corresponding column size in the table.
1983: l_supplier_name po_vendors.VENDOR_NAME%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: