APPS.INV_LABEL_PVT1 dependencies on MTL_CYCLE_COUNT_HEADERS

Line 1971: FROM mtl_cycle_count_headers mcch,

1967: mcce.subinventory,
1968: mcce.locator_id,
1969: mcch.cycle_count_header_name,
1970: ppf.full_name requestor
1971: FROM mtl_cycle_count_headers mcch,
1972: mtl_cycle_count_entries mcce,
1973: per_people_f ppf
1974: WHERE mcce.cycle_count_entry_id = p_transaction_Id
1975: AND ppf.person_id(+) = mcce.counted_by_employee_id_current

Line 1986: FROM mtl_cycle_count_headers mcch,

1982:
1983: CURSOR cc_det_approval IS
1984: SELECT mcch.cycle_count_header_name,
1985: ppf.full_name requestor
1986: FROM mtl_cycle_count_headers mcch,
1987: mtl_cycle_count_entries mcce,
1988: per_people_f ppf,
1989: mtl_material_transactions_temp mmtt
1990: WHERE mmtt.transaction_temp_id= p_transaction_id

Line 2140: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;

2136: l_label_format_set_id NUMBER;
2137:
2138: l_is_expense_item BOOLEAN := FALSE; /* Added for the bug # 4708752 */
2139: --Bug 4891916. Added the local variable to store the cycle count name
2140: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;
2141:
2142: v_material_cur c_material_cur%ROWTYPE; --Added for Bug 6504959
2143: l_moqd_quantity number;--added for bug 6646793
2144: l_mmtt_quantity number;--added for bug 6646793