APPS.INV_LABEL_PVT3 dependencies on MTL_CYCLE_COUNT_HEADERS

Line 385: FROM mtl_cycle_count_headers mcch,

381: , ppf.full_name requestor
382: , mcce.organization_id --Conf Label ER
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

Line 400: FROM mtl_cycle_count_headers mcch,

396:
397: CURSOR cc_det_approval IS
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

Line 543: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;

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;
547: