DBA Data[Home] [Help]

APPS.INV_UI_ITEM_SUB_LOC_LOVS dependencies on MTL_CYCLE_COUNT_HEADERS

Line 2560: FROM mtl_cycle_count_headers

2556: l_ispjm_org:='N';
2557: END; -- Get the cycle count discrepancy option flags
2558: SELECT NVL(serial_discrepancy_option, 2), NVL(container_discrepancy_option, 2)
2559: INTO l_serial_discrepancy_option, l_container_discrepancy_option
2560: FROM mtl_cycle_count_headers
2561: WHERE cycle_count_header_id = p_cycle_count_header_id;
2562:
2563: IF (l_debug = 1) THEN
2564: Inv_log_util.trace('l_serial_discrepancy_option: ' || l_serial_discrepancy_option , l_proc_name,9);

Line 2748: FROM mtl_cycle_count_headers

2744: l_ispjm_org:='N';
2745: END; -- Get the cycle count discrepancy option flags
2746: SELECT NVL(serial_discrepancy_option, 2), NVL(container_discrepancy_option, 2)
2747: INTO l_serial_discrepancy_option, l_container_discrepancy_option
2748: FROM mtl_cycle_count_headers
2749: WHERE cycle_count_header_id = p_cycle_count_header_id;
2750:
2751: IF (l_debug = 1) THEN
2752: Inv_log_util.trace('l_serial_discrepancy_option: ' || l_serial_discrepancy_option , l_proc_name,9);