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

Line 387: per_people_f ppf

383: , mcce.inventory_item_id --Conf Label ER
384: , mcce.revision--Conf Label ER
385: FROM mtl_cycle_count_headers mcch,
386: mtl_cycle_count_entries mcce,
387: per_people_f ppf
388: WHERE cycle_count_entry_id= p_transaction_id
389: AND ppf.person_id(+) = mcce.counted_by_employee_id_current
390: AND mcce.cycle_count_header_id=mcch.cycle_count_header_id;
391: /* End of fix for Bug 4891916 */

Line 402: per_people_f ppf,

398: SELECT mcch.cycle_count_header_name,
399: ppf.full_name requestor
400: FROM mtl_cycle_count_headers mcch,
401: mtl_cycle_count_entries mcce,
402: per_people_f ppf,
403: mtl_material_transactions_temp mmtt
404: WHERE mmtt.transaction_temp_id= p_transaction_id
405: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id
406: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id

Line 542: l_requestor per_people_f.full_name%TYPE;

538: -- a list of columns that are selected for format
539: l_column_name_list LONG;
540:
541: --Bug 4891916. Added the following local variables to store the counter and cycle count name.
542: l_requestor per_people_f.full_name%TYPE;
543: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;
544:
545: l_patch_level NUMBER;
546: l_count NUMBER;