DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on MTL_CYCLE_COUNT_HEADERS

Line 1560: FROM mtl_cycle_count_headers

1556: SELECT NVL(serial_discrepancy_option, 2)
1557: , NVL(container_discrepancy_option, 2)
1558: INTO l_serial_discrepancy_option
1559: , l_container_discrepancy_option
1560: FROM mtl_cycle_count_headers
1561: WHERE cycle_count_header_id = p_cycle_count_header_id;
1562:
1563: -- Get the serial count option for the cycle count header
1564: SELECT NVL(serial_count_option, 1)

Line 1566: FROM mtl_cycle_count_headers

1562:
1563: -- Get the serial count option for the cycle count header
1564: SELECT NVL(serial_count_option, 1)
1565: INTO l_serial_count_option
1566: FROM mtl_cycle_count_headers
1567: WHERE cycle_count_header_id = p_cycle_count_header_id
1568: AND organization_id = p_organization_id;
1569:
1570: -- Get the serial number control code for the item