DBA Data[Home] [Help]

APPS.RLM_EXTINTERFACE_SV dependencies on FND_LOOKUP_VALUES

Line 2028: FROM fnd_lookup_values lv

2024: IF v_released_count = v_total_count THEN
2025: --
2026: SELECT meaning
2027: INTO v_line_status
2028: FROM fnd_lookup_values lv
2029: WHERE lookup_type = 'LINE_FLOW_STATUS'
2030: AND lookup_code = 'PICKED'
2031: AND LANGUAGE = userenv('LANG')
2032: AND VIEW_APPLICATION_ID = 660

Line 2041: FROM fnd_lookup_values lv

2037: ELSIF v_released_count < v_total_count and v_released_count <> 0 THEN
2038: --
2039: SELECT meaning
2040: INTO v_line_status
2041: FROM fnd_lookup_values lv
2042: WHERE lookup_type = 'LINE_FLOW_STATUS'
2043: AND lookup_code = 'PICKED_PARTIAL'
2044: AND LANGUAGE = userenv('LANG')
2045: AND VIEW_APPLICATION_ID = 660

Line 2054: FROM fnd_lookup_values lv

2050: ELSE
2051: --
2052: SELECT meaning
2053: INTO v_line_status
2054: FROM fnd_lookup_values lv
2055: WHERE lookup_type = 'LINE_FLOW_STATUS'
2056: AND lookup_code = v_status_code
2057: AND LANGUAGE = userenv('LANG')
2058: AND VIEW_APPLICATION_ID = 660