APPS.INV_LABEL_PVT5 dependencies on MTL_CYCLE_COUNT_HEADERS

Line 988: FROM mtl_cycle_count_headers mcch

984: , mcce.locator_id
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

Line 1002: FROM mtl_cycle_count_headers mcch

998: --counter for the entry for the label printed at the time of cycle count approval
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

Line 1305: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;

1301:
1302: l_count_custom_sql NUMBER := 0; -- Added for Bug#4179391
1303:
1304: --Bug 4891916. Added the local variable to store the cycle count name
1305: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;
1306: --lpn status project start
1307: l_material_status_code varchar2(30) := NULL;
1308: l_onhand_status_enabled NUMBER := 0;
1309: --lpn status project end