APPS.INV_LABEL_PVT3 dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 386: mtl_cycle_count_entries mcce,

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
390: AND mcce.cycle_count_header_id=mcch.cycle_count_header_id;

Line 401: mtl_cycle_count_entries mcce,

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
405: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id