DBA Data[Home] [Help]

APPS.INV_LABEL_PVT1 dependencies on MTL_CYCLE_COUNT_HEADERS

Line 1920: FROM mtl_cycle_count_headers mcch,

1916: mcce.subinventory,
1917: mcce.locator_id,
1918: mcch.cycle_count_header_name,
1919: ppf.full_name requestor
1920: FROM mtl_cycle_count_headers mcch,
1921: mtl_cycle_count_entries mcce,
1922: per_people_f ppf
1923: WHERE mcce.cycle_count_entry_id = p_transaction_Id
1924: AND ppf.person_id(+) = mcce.counted_by_employee_id_current

Line 1935: FROM mtl_cycle_count_headers mcch,

1931:
1932: CURSOR cc_det_approval IS
1933: SELECT mcch.cycle_count_header_name,
1934: ppf.full_name requestor
1935: FROM mtl_cycle_count_headers mcch,
1936: mtl_cycle_count_entries mcce,
1937: per_people_f ppf,
1938: mtl_material_transactions_temp mmtt
1939: WHERE mmtt.transaction_temp_id= p_transaction_id

Line 2018: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;

2014: l_label_format_set_id NUMBER;
2015:
2016: l_is_expense_item BOOLEAN := FALSE; /* Added for the bug # 4708752 */
2017: --Bug 4891916. Added the local variable to store the cycle count name
2018: l_cycle_count_name mtl_cycle_count_headers.cycle_count_header_name%TYPE;
2019:
2020: v_material_cur c_material_cur%ROWTYPE; --Added for Bug 6504959
2021: l_moqd_quantity number;--added for bug 6646793
2022: l_mmtt_quantity number;--added for bug 6646793