DBA Data[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 989: , mtl_cycle_count_entries mcce

985: , mcce.parent_lpn_id
986: , mcch.cycle_count_header_name
987: , ppf.full_name requestor
988: FROM mtl_cycle_count_headers mcch
989: , mtl_cycle_count_entries mcce
990: , per_people_f ppf
991: WHERE mcce.cycle_count_entry_id = p_transaction_Id
992: AND ppf.person_id(+) = mcce.counted_by_employee_id_current
993: AND mcce.cycle_count_header_id=mcch.cycle_count_header_id;

Line 1003: , mtl_cycle_count_entries mcce

999: CURSOR cc_det_approval IS
1000: SELECT mcch.cycle_count_header_name
1001: , ppf.full_name requestor
1002: FROM mtl_cycle_count_headers mcch
1003: , mtl_cycle_count_entries mcce
1004: , per_people_f ppf
1005: , mtl_material_transactions_temp mmtt
1006: WHERE mmtt.transaction_temp_id= p_transaction_id
1007: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id