APPS.INV_INV_LOVS dependencies on MFG_LOOKUPS

Line 1828: FROM mfg_lookups

1824: IF (p_wms_installed IN ('true', 'TRUE')) THEN
1825: OPEN x_source_lov FOR
1826: SELECT meaning
1827: , lookup_code
1828: FROM mfg_lookups
1829: WHERE lookup_type = 'WMS_LABEL_TYPE'
1830: AND lookup_code NOT IN (9)
1831: AND meaning LIKE (p_lookup_type)
1832: ORDER BY lookup_code;

Line 1837: FROM mfg_lookups

1833: ELSE
1834: OPEN x_source_lov FOR
1835: SELECT meaning
1836: , lookup_code
1837: FROM mfg_lookups
1838: WHERE lookup_type = 'WMS_LABEL_TYPE'
1839: AND lookup_code IN (1, 2, 6, 7, 8, 10)
1840: AND meaning LIKE (p_lookup_type)
1841: ORDER BY lookup_code;

Line 1854: FROM mfg_lookups

1850: IF (p_wms_installed IN ('true', 'TRUE')) THEN
1851: OPEN x_source_lov FOR
1852: SELECT meaning
1853: , lookup_code
1854: FROM mfg_lookups
1855: WHERE lookup_type = 'WMS_LABEL_TYPE'
1856: AND meaning LIKE (p_lookup_type)
1857: ORDER BY lookup_code;
1858: ELSE

Line 1862: FROM mfg_lookups

1858: ELSE
1859: OPEN x_source_lov FOR
1860: SELECT meaning
1861: , lookup_code
1862: FROM mfg_lookups
1863: WHERE lookup_type = 'WMS_LABEL_TYPE'
1864: AND lookup_code IN (1, 2, 6, 7, 8, 10)
1865: AND meaning LIKE (p_lookup_type)
1866: ORDER BY lookup_code;

Line 1877: FROM mfg_lookups

1873: IF (p_wms_installed IN ('true', 'TRUE')) THEN -- WMS Enabled.
1874: OPEN x_source_lov FOR
1875: SELECT meaning
1876: , lookup_code
1877: FROM mfg_lookups
1878: WHERE lookup_type = 'WMS_BUSINESS_FLOW'
1879: AND lookup_code NOT IN (3)
1880: AND meaning LIKE (p_lookup_type)
1881: ORDER BY lookup_code;

Line 1886: FROM mfg_lookups

1882: ELSE -- INV Enabled.
1883: OPEN x_source_lov FOR
1884: SELECT meaning
1885: , lookup_code
1886: FROM mfg_lookups
1887: WHERE lookup_type = 'WMS_BUSINESS_FLOW'
1888: AND lookup_code IN (1, 2, 3, 8, 9, 13, 14, 15, 17, 21, 23, 24, 26, 31, 32, 33)
1889: AND meaning LIKE (p_lookup_type)
1890: ORDER BY lookup_code;

Line 1917: FROM mfg_lookups

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
1918: WHERE lookup_type = 'WMS_LABEL_TYPE'
1919: AND meaning LIKE (p_lookup_type)
1920: ORDER BY lookup_code;
1921: ELSE

Line 1928: FROM mfg_lookups

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
1929: WHERE lookup_type = 'WMS_LABEL_TYPE'
1930: AND lookup_code NOT IN (3,4,5,9)
1931: AND meaning LIKE (p_lookup_type)
1932: ORDER BY lookup_code;