APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_CYCLE_COUNT_HEADERS

Line 1091: FROM mtl_cycle_count_headers

1087: NVL(container_discrepancy_option, 2),
1088: NVL(orientation_code, 1)
1089: INTO l_serial_discrepancy_option, l_container_discrepancy_option,
1090: l_orientation_code
1091: FROM mtl_cycle_count_headers
1092: WHERE cycle_count_header_id = p_cycle_count_header_id;
1093:
1094: IF (p_unscheduled_entry = 1) THEN
1095: -- Unscheduled entries are allowed

Line 1320: FROM mtl_cycle_count_headers

1316: NVL(container_discrepancy_option, 2),
1317: NVL(orientation_code, 1)
1318: INTO l_serial_discrepancy_option, l_container_discrepancy_option,
1319: l_orientation_code
1320: FROM mtl_cycle_count_headers
1321: WHERE cycle_count_header_id = p_cycle_count_header_id;
1322:
1323: l_temp_boolean :=
1324: mtl_serial_check.inv_serial_info(p_from_serial_number, NULL, l_prefix,

Line 1544: FROM mtl_cycle_count_headers

1540: BEGIN
1541: -- Get the cycle count serial discrepancy option and orientation code
1542: SELECT NVL(serial_discrepancy_option, 2), NVL(orientation_code, 1)
1543: INTO l_serial_discrepancy_option, l_orientation_code
1544: FROM mtl_cycle_count_headers
1545: WHERE cycle_count_header_id = p_cycle_count_header_id;
1546:
1547: IF (p_unscheduled_entry = 1) THEN
1548: -- Unscheduled entries are allowed