APPS.INV_INV_LOVS dependencies on MFG_LOOKUPS

Line 1804: FROM mfg_lookups

1800: IF (p_wms_installed IN ('true', 'TRUE')) THEN
1801: OPEN x_source_lov FOR
1802: SELECT meaning
1803: , lookup_code
1804: FROM mfg_lookups
1805: WHERE lookup_type = 'WMS_LABEL_TYPE'
1806: AND lookup_code NOT IN (9)
1807: AND meaning LIKE (p_lookup_type)
1808: ORDER BY lookup_code;

Line 1813: FROM mfg_lookups

1809: ELSE
1810: OPEN x_source_lov FOR
1811: SELECT meaning
1812: , lookup_code
1813: FROM mfg_lookups
1814: WHERE lookup_type = 'WMS_LABEL_TYPE'
1815: AND lookup_code IN (1, 2, 6, 7, 8, 10)
1816: AND meaning LIKE (p_lookup_type)
1817: ORDER BY lookup_code;

Line 1830: FROM mfg_lookups

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

Line 1838: FROM mfg_lookups

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

Line 1853: FROM mfg_lookups

1849: IF (p_wms_installed IN ('true', 'TRUE')) THEN -- WMS Enabled.
1850: OPEN x_source_lov FOR
1851: SELECT meaning
1852: , lookup_code
1853: FROM mfg_lookups
1854: WHERE lookup_type = 'WMS_BUSINESS_FLOW'
1855: AND lookup_code NOT IN (3)
1856: AND meaning LIKE (p_lookup_type)
1857: ORDER BY lookup_code;

Line 1862: FROM mfg_lookups

1858: ELSE -- INV Enabled.
1859: OPEN x_source_lov FOR
1860: SELECT meaning
1861: , lookup_code
1862: FROM mfg_lookups
1863: WHERE lookup_type = 'WMS_BUSINESS_FLOW'
1864: AND lookup_code IN (1, 2, 3, 8, 9, 13, 14, 15, 17, 21, 23, 24, 26, 31, 32, 33)
1865: AND meaning LIKE (p_lookup_type)
1866: ORDER BY lookup_code;

Line 1893: FROM mfg_lookups

1889: FROM DUAL
1890: WHERE p_all_label_str LIKE (p_lookup_type)
1891: UNION ALL
1892: SELECT meaning, lookup_code
1893: FROM mfg_lookups
1894: WHERE lookup_type = 'WMS_LABEL_TYPE'
1895: AND meaning LIKE (p_lookup_type)
1896: ORDER BY lookup_code;
1897: ELSE

Line 1904: FROM mfg_lookups

1900: FROM DUAL
1901: WHERE p_all_label_str LIKE (p_lookup_type)
1902: UNION ALL
1903: SELECT meaning, lookup_code
1904: FROM mfg_lookups
1905: WHERE lookup_type = 'WMS_LABEL_TYPE'
1906: AND lookup_code NOT IN (3,4,5,9)
1907: AND meaning LIKE (p_lookup_type)
1908: ORDER BY lookup_code;