APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_CYCLE_COUNT_HEADERS

Line 2183: FROM mtl_cycle_count_headers

2179: l_ispjm_org:='N';
2180: END; -- Get the cycle count discrepancy option flags
2181: SELECT NVL(serial_discrepancy_option, 2), NVL(container_discrepancy_option, 2)
2182: INTO l_serial_discrepancy_option, l_container_discrepancy_option
2183: FROM mtl_cycle_count_headers
2184: WHERE cycle_count_header_id = p_cycle_count_header_id;
2185:
2186: IF (l_debug = 1) THEN
2187: Inv_log_util.trace('l_serial_discrepancy_option: ' || l_serial_discrepancy_option , l_proc_name,9);

Line 2371: FROM mtl_cycle_count_headers

2367: l_ispjm_org:='N';
2368: END; -- Get the cycle count discrepancy option flags
2369: SELECT NVL(serial_discrepancy_option, 2), NVL(container_discrepancy_option, 2)
2370: INTO l_serial_discrepancy_option, l_container_discrepancy_option
2371: FROM mtl_cycle_count_headers
2372: WHERE cycle_count_header_id = p_cycle_count_header_id;
2373:
2374: IF (l_debug = 1) THEN
2375: Inv_log_util.trace('l_serial_discrepancy_option: ' || l_serial_discrepancy_option , l_proc_name,9);