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 377: , per_people_f ppf

373: , po_vendors pov
374: , hr_locations_all hrl1
375: , hr_locations_all hrl2
376: , po_vendor_sites_all pvs
377: , per_people_f ppf
378: , rcv_routing_headers rrh
379: , wip_osp_jobs_val_v wojv
380: WHERE wlc.parent_lpn_id(+) = rti.lpn_id
381: AND wlc.inventory_item_id(+) = rti.item_id -- bug 2372669

Line 459: , per_people_f ppf

455: , po_vendors pov
456: , hr_locations_all hrl1
457: , hr_locations_all hrl2
458: , po_vendor_sites_all pvs
459: , per_people_f ppf
460: , rcv_routing_headers rrh
461: , wip_osp_jobs_val_v wojv
462: WHERE wlc.parent_lpn_id(+) = rti.transfer_lpn_id
463: AND wlc.inventory_item_id(+) = rti.item_id -- bug 2372669

Line 720: , per_people_f ppf

716: , po_vendors pov
717: , hr_locations_all hrl1
718: , hr_locations_all hrl2
719: , po_vendor_sites_all pvs
720: , per_people_f ppf
721: , rcv_routing_headers rrh
722: -- Bug 4516067, to improve performance, query the base table directly
723: --, wip_osp_jobs_val_v wojv
724: , wip_entities we -- Added for Bug#4516067

Line 918: , per_people_f ppf

914: , po_vendors pov
915: , hr_locations_all hrl1
916: , hr_locations_all hrl2
917: , po_vendor_sites_all pvs
918: , per_people_f ppf
919: , rcv_routing_headers rrh
920: -- Bug 4516067, to improve performance, query the base table directly
921: --, wip_osp_jobs_val_v wojv
922: , wip_entities we

Line 1101: , per_people_f ppf

1097: , po_vendors pov
1098: , hr_locations_all hrl1
1099: , hr_locations_all hrl2
1100: , po_vendor_sites_all pvs
1101: , per_people_f ppf
1102: , rcv_routing_headers rrh
1103: -- Bug 4516067, to improve performance, query the base table directly
1104: --, wip_osp_jobs_val_v wojv
1105: , wip_entities we

Line 1973: per_people_f ppf

1969: mcch.cycle_count_header_name,
1970: ppf.full_name requestor
1971: FROM mtl_cycle_count_headers mcch,
1972: mtl_cycle_count_entries mcce,
1973: per_people_f ppf
1974: WHERE mcce.cycle_count_entry_id = p_transaction_Id
1975: AND ppf.person_id(+) = mcce.counted_by_employee_id_current
1976: AND mcce.cycle_count_header_id=mcch.cycle_count_header_id;
1977:

Line 1988: per_people_f ppf,

1984: SELECT mcch.cycle_count_header_name,
1985: ppf.full_name requestor
1986: FROM mtl_cycle_count_headers mcch,
1987: mtl_cycle_count_entries mcce,
1988: per_people_f ppf,
1989: mtl_material_transactions_temp mmtt
1990: WHERE mmtt.transaction_temp_id= p_transaction_id
1991: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id
1992: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id

Line 2107: l_requestor per_people_f.FULL_NAME%TYPE;

2103:
2104: -- Increased this variable size to the corresponding column size in the table.
2105: l_supplier_name po_vendors.VENDOR_NAME%TYPE;
2106: l_supplier_site po_vendor_sites.VENDOR_SITE_CODE%TYPE;
2107: l_requestor per_people_f.FULL_NAME%TYPE;
2108: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;
2109: l_location_code hr_locations_all.LOCATION_CODE%TYPE;
2110: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;
2111: