DBA Data[Home] [Help]

APPS.INV_INV_LOVS dependencies on DUAL

Line 1913: FROM DUAL

1909: BEGIN
1910: IF ( p_wms_installed IN('true','TRUE') ) THEN
1911: OPEN x_source_lov FOR
1912: SELECT p_all_label_str meaning, 0 lookup_code
1913: FROM DUAL
1914: WHERE p_all_label_str LIKE (p_lookup_type)
1915: UNION ALL
1916: SELECT meaning, lookup_code
1917: FROM mfg_lookups

Line 1924: FROM DUAL

1920: ORDER BY lookup_code;
1921: ELSE
1922: OPEN x_source_lov FOR
1923: SELECT p_all_label_str meaning, 0 lookup_code
1924: FROM DUAL
1925: WHERE p_all_label_str LIKE (p_lookup_type)
1926: UNION ALL
1927: SELECT meaning, lookup_code
1928: FROM mfg_lookups