DBA Data[Home] [Help]

APPS.INV_LABEL_PVT5 dependencies on MTL_CYCLE_COUNT_ENTRIES

Line 1134: , mtl_cycle_count_entries mcce

1130: , mcce.parent_lpn_id
1131: , mcch.cycle_count_header_name
1132: , ppf.full_name requestor
1133: FROM mtl_cycle_count_headers mcch
1134: , mtl_cycle_count_entries mcce
1135: , per_people_f ppf
1136: WHERE mcce.cycle_count_entry_id = p_transaction_Id
1137: AND ppf.person_id(+) = mcce.counted_by_employee_id_current
1138: AND mcce.cycle_count_header_id=mcch.cycle_count_header_id;

Line 1148: , mtl_cycle_count_entries mcce

1144: CURSOR cc_det_approval IS
1145: SELECT mcch.cycle_count_header_name
1146: , ppf.full_name requestor
1147: FROM mtl_cycle_count_headers mcch
1148: , mtl_cycle_count_entries mcce
1149: , per_people_f ppf
1150: , mtl_material_transactions_temp mmtt
1151: WHERE mmtt.transaction_temp_id= p_transaction_id
1152: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id