APPS.INV_UI_ITEM_ATT_LOVS dependencies on MTL_CYCLE_COUNT_HEADERS

Line 1154: FROM mtl_cycle_count_headers

1150: NVL(container_discrepancy_option, 2),
1151: NVL(orientation_code, 1)
1152: INTO l_serial_discrepancy_option, l_container_discrepancy_option,
1153: l_orientation_code
1154: FROM mtl_cycle_count_headers
1155: WHERE cycle_count_header_id = p_cycle_count_header_id;
1156:
1157: IF (p_unscheduled_entry = 1) THEN
1158: -- Unscheduled entries are allowed

Line 1383: FROM mtl_cycle_count_headers

1379: NVL(container_discrepancy_option, 2),
1380: NVL(orientation_code, 1)
1381: INTO l_serial_discrepancy_option, l_container_discrepancy_option,
1382: l_orientation_code
1383: FROM mtl_cycle_count_headers
1384: WHERE cycle_count_header_id = p_cycle_count_header_id;
1385:
1386: l_temp_boolean :=
1387: mtl_serial_check.inv_serial_info(p_from_serial_number, NULL, l_prefix,

Line 1607: FROM mtl_cycle_count_headers

1603: BEGIN
1604: -- Get the cycle count serial discrepancy option and orientation code
1605: SELECT NVL(serial_discrepancy_option, 2), NVL(orientation_code, 1)
1606: INTO l_serial_discrepancy_option, l_orientation_code
1607: FROM mtl_cycle_count_headers
1608: WHERE cycle_count_header_id = p_cycle_count_header_id;
1609:
1610: IF (p_unscheduled_entry = 1) THEN
1611: -- Unscheduled entries are allowed