APPS.INV_LABEL_PVT3 dependencies on MTL_CYCLE_COUNT_HEADERS

Line 355: FROM mtl_cycle_count_headers mcch,

351: , subinventory
352: , locator_id
353: , mcch.cycle_count_header_name
354: , ppf.full_name requestor
355: FROM mtl_cycle_count_headers mcch,
356: mtl_cycle_count_entries mcce,
357: per_people_f ppf
358: WHERE cycle_count_entry_id= p_transaction_id
359: AND ppf.person_id(+) = mcce.counted_by_employee_id_current

Line 370: FROM mtl_cycle_count_headers mcch,

366:
367: CURSOR cc_det_approval IS
368: SELECT mcch.cycle_count_header_name,
369: ppf.full_name requestor
370: FROM mtl_cycle_count_headers mcch,
371: mtl_cycle_count_entries mcce,
372: per_people_f ppf,
373: mtl_material_transactions_temp mmtt
374: WHERE mmtt.transaction_temp_id= p_transaction_id

Line 513: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;

509: l_column_name_list LONG;
510:
511: --Bug 4891916. Added the following local variables to store the counter and cycle count name.
512: l_requestor per_people_f.full_name%TYPE;
513: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;
514:
515: l_patch_level NUMBER;
516: l_count NUMBER;
517: