DBA Data[Home] [Help]

APPS.INV_UI_ITEM_LOVS dependencies on MTL_CYCLE_COUNT_HEADERS

Line 2743: FROM mtl_cycle_count_headers

2739: SELECT NVL(serial_discrepancy_option, 2)
2740: , NVL(container_discrepancy_option, 2)
2741: INTO l_serial_discrepancy_option
2742: , l_container_discrepancy_option
2743: FROM mtl_cycle_count_headers
2744: WHERE cycle_count_header_id = p_cycle_count_header_id;
2745:
2746: -- Get the serial count option for the cycle count header
2747: SELECT NVL(serial_count_option, 1)

Line 2749: FROM mtl_cycle_count_headers

2745:
2746: -- Get the serial count option for the cycle count header
2747: SELECT NVL(serial_count_option, 1)
2748: INTO l_serial_count_option
2749: FROM mtl_cycle_count_headers
2750: WHERE cycle_count_header_id = p_cycle_count_header_id
2751: AND organization_id = p_organization_id;
2752:
2753: IF (p_unscheduled_entry = 1) THEN -- Unscheduled entries are allowed