DBA Data[Home] [Help]

APPS.INV_UI_ITEM_LOVS dependencies on MTL_CYCLE_COUNT_HEADERS

Line 2594: FROM mtl_cycle_count_headers

2590: SELECT NVL(serial_discrepancy_option, 2)
2591: , NVL(container_discrepancy_option, 2)
2592: INTO l_serial_discrepancy_option
2593: , l_container_discrepancy_option
2594: FROM mtl_cycle_count_headers
2595: WHERE cycle_count_header_id = p_cycle_count_header_id;
2596:
2597: -- Get the serial count option for the cycle count header
2598: SELECT NVL(serial_count_option, 1)

Line 2600: FROM mtl_cycle_count_headers

2596:
2597: -- Get the serial count option for the cycle count header
2598: SELECT NVL(serial_count_option, 1)
2599: INTO l_serial_count_option
2600: FROM mtl_cycle_count_headers
2601: WHERE cycle_count_header_id = p_cycle_count_header_id
2602: AND organization_id = p_organization_id;
2603:
2604: IF (p_unscheduled_entry = 1) THEN -- Unscheduled entries are allowed