DBA Data[Home] [Help]

APPS.RLM_EXTINTERFACE_SV dependencies on FND_LOOKUP_VALUES

Line 1852: FROM fnd_lookup_values lv

1848: IF v_released_count = v_total_count THEN
1849: --
1850: SELECT meaning
1851: INTO v_line_status
1852: FROM fnd_lookup_values lv
1853: WHERE lookup_type = 'LINE_FLOW_STATUS'
1854: AND lookup_code = 'PICKED'
1855: AND LANGUAGE = userenv('LANG')
1856: AND VIEW_APPLICATION_ID = 660

Line 1865: FROM fnd_lookup_values lv

1861: ELSIF v_released_count < v_total_count and v_released_count <> 0 THEN
1862: --
1863: SELECT meaning
1864: INTO v_line_status
1865: FROM fnd_lookup_values lv
1866: WHERE lookup_type = 'LINE_FLOW_STATUS'
1867: AND lookup_code = 'PICKED_PARTIAL'
1868: AND LANGUAGE = userenv('LANG')
1869: AND VIEW_APPLICATION_ID = 660

Line 1878: FROM fnd_lookup_values lv

1874: ELSE
1875: --
1876: SELECT meaning
1877: INTO v_line_status
1878: FROM fnd_lookup_values lv
1879: WHERE lookup_type = 'LINE_FLOW_STATUS'
1880: AND lookup_code = v_status_code
1881: AND LANGUAGE = userenv('LANG')
1882: AND VIEW_APPLICATION_ID = 660