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

Line 143: po_vendor_sites_all pvs, per_people_f ppf

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
143: po_vendor_sites_all pvs, per_people_f ppf
144: where rti.interface_transaction_id = p_transaction_id
145: AND rti.po_header_id = pha.po_header_id(+)
146: AND rsh.shipment_header_id(+) = rti.shipment_header_id
147: AND pol.po_line_id (+) = rti.po_line_id

Line 175: po_vendor_sites_all pvs, per_people_f ppf

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
175: po_vendor_sites_all pvs, per_people_f ppf
176: where rti.interface_transaction_id = p_transaction_id
177: AND rti.po_header_id = pha.po_header_id(+)
178: AND rsh.shipment_header_id(+) = rti.shipment_header_id
179: AND pol.po_line_id (+) = rti.po_line_id

Line 396: , per_people_f ppf

392: -- , hr_locations_all hrl1
393: -- , hr_locations_all hrl2
394: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
395: , po_vendor_sites_all pvs
396: , per_people_f ppf
397: , wms_license_plate_numbers wlpn
398: WHERE pha.po_header_id(+) = all_lpn.po_header_id
399: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
400: AND rsh.shipment_header_id = rsl.shipment_header_id

Line 1205: per_people_f ppf

1201: hr_locations_all hrl2
1202: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
1203: ,
1204: po_vendor_sites_all pvs ,
1205: per_people_f ppf
1206: WHERE pha.po_header_id(+) = all_lpn.po_header_id
1207: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
1208: AND pol.po_line_id (+) = all_lpn.po_line_id
1209: AND pol.po_header_id (+) = all_lpn.po_header_id

Line 1344: , per_people_f ppf

1340: , mcch.cycle_count_header_name
1341: , ppf.full_name requestor
1342: FROM mtl_cycle_count_headers mcch
1343: , mtl_cycle_count_entries mcce
1344: , per_people_f ppf
1345: WHERE mcce.cycle_count_entry_id = p_transaction_Id
1346: AND ppf.person_id(+) = mcce.counted_by_employee_id_current
1347: AND ppf.EFFECTIVE_END_DATE(+) >= trunc(sysdate)
1348: AND mcce.cycle_count_header_id=mcch.cycle_count_header_id;

Line 1357: , per_people_f ppf

1353: SELECT mcch.cycle_count_header_name
1354: , ppf.full_name requestor
1355: FROM mtl_cycle_count_headers mcch
1356: , mtl_cycle_count_entries mcce
1357: , per_people_f ppf
1358: , mtl_material_transactions_temp mmtt
1359: WHERE mmtt.transaction_temp_id= p_transaction_id
1360: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id
1361: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id

Line 1444: l_requestor per_people_f.FULL_NAME%TYPE;

1440:
1441: -- Increased this variable size to the corresponding column size in the table.
1442: l_supplier_name po_vendors.VENDOR_NAME%TYPE;
1443: l_supplier_site po_vendor_sites.VENDOR_SITE_CODE%TYPE;
1444: l_requestor per_people_f.FULL_NAME%TYPE;
1445: l_deliver_to_location hr_locations_all.LOCATION_CODE%TYPE;
1446: l_location_code hr_locations_all.LOCATION_CODE%TYPE;
1447: l_note_to_receiver po_line_locations.NOTE_TO_RECEIVER%TYPE;
1448: