DBA Data[Home] [Help]

APPS.INV_LABEL_PVT3 dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 356: mtl_cycle_count_entries mcce,

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

Line 371: mtl_cycle_count_entries mcce,

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