DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on MTL_CYCLE_COUNT_HEADERS

Line 1584: FROM mtl_cycle_count_headers

1580: SELECT NVL(serial_discrepancy_option, 2)
1581: , NVL(container_discrepancy_option, 2)
1582: INTO l_serial_discrepancy_option
1583: , l_container_discrepancy_option
1584: FROM mtl_cycle_count_headers
1585: WHERE cycle_count_header_id = p_cycle_count_header_id;
1586:
1587: -- Get the serial count option for the cycle count header
1588: SELECT NVL(serial_count_option, 1)

Line 1590: FROM mtl_cycle_count_headers

1586:
1587: -- Get the serial count option for the cycle count header
1588: SELECT NVL(serial_count_option, 1)
1589: INTO l_serial_count_option
1590: FROM mtl_cycle_count_headers
1591: WHERE cycle_count_header_id = p_cycle_count_header_id
1592: AND organization_id = p_organization_id;
1593:
1594: -- Get the serial number control code for the item