eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_BULK_VALUE_TO_ID dependencies on OE_LOOKUPS

Line 573: FROM OE_LOOKUPS b, OE_HEADERS_IFACE_ALL d

569: (SELECT b.LOOKUP_CODE,
570: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
571: DECODE(b.LOOKUP_CODE,NULL,
572: c.ATTRIBUTE_STATUS||'011',c.ATTRIBUTE_STATUS)
573: FROM OE_LOOKUPS b, OE_HEADERS_IFACE_ALL d
574: WHERE d.FREIGHT_TERMS = b.MEANING(+)
575: AND b.LOOKUP_TYPE(+) = 'FREIGHT_TERMS'
576: AND b.enabled_flag(+) = 'Y'
577: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 910: FROM OE_LOOKUPS b, OE_HEADERS_IFACE_ALL d

906: (SELECT b.LOOKUP_CODE,
907: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
908: DECODE(b.LOOKUP_CODE,NULL,
909: c.ATTRIBUTE_STATUS||'022',c.ATTRIBUTE_STATUS)
910: FROM OE_LOOKUPS b, OE_HEADERS_IFACE_ALL d
911: WHERE d.SALES_CHANNEL = b.MEANING(+)
912: AND b.LOOKUP_TYPE(+) = 'SALES_CHANNEL'
913: AND b.enabled_flag(+) = 'Y'
914: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 930: FROM OE_LOOKUPS b, OE_HEADERS_IFACE_ALL d

926: (SELECT b.LOOKUP_CODE,
927: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
928: DECODE(b.LOOKUP_CODE,NULL,
929: c.ATTRIBUTE_STATUS||'023',c.ATTRIBUTE_STATUS)
930: FROM OE_LOOKUPS b, OE_HEADERS_IFACE_ALL d
931: WHERE d.SHIPMENT_PRIORITY = b.MEANING(+)
932: AND b.LOOKUP_TYPE(+) = 'SHIPMENT_PRIORITY'
933: AND b.enabled_flag(+) = 'Y'
934: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1064: FROM -- OE_LOOKUPS b,

1060: (SELECT b.LOOKUP_CODE,
1061: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1062: DECODE(b.LOOKUP_CODE,NULL,
1063: c.ATTRIBUTE_STATUS||'028',c.ATTRIBUTE_STATUS)
1064: FROM -- OE_LOOKUPS b,
1065: ( select lookup_code, meaning
1066: from OE_LOOKUPS
1067: where lookup_type In ('ITEM_OWNER', 'ONT_INSTALL_BASE')
1068: and enabled_flag = 'Y'

Line 1066: from OE_LOOKUPS

1062: DECODE(b.LOOKUP_CODE,NULL,
1063: c.ATTRIBUTE_STATUS||'028',c.ATTRIBUTE_STATUS)
1064: FROM -- OE_LOOKUPS b,
1065: ( select lookup_code, meaning
1066: from OE_LOOKUPS
1067: where lookup_type In ('ITEM_OWNER', 'ONT_INSTALL_BASE')
1068: and enabled_flag = 'Y'
1069: and SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1070: AND NVL(END_DATE_ACTIVE, SYSDATE) ) b,

Line 1090: FROM -- OE_LOOKUPS b,

1086: (SELECT b.LOOKUP_CODE,
1087: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1088: DECODE(b.LOOKUP_CODE,NULL,
1089: c.ATTRIBUTE_STATUS||'029',c.ATTRIBUTE_STATUS)
1090: FROM -- OE_LOOKUPS b,
1091: ( select lookup_code, meaning
1092: from OE_LOOKUPS
1093: where lookup_type In ('ITEM_INSTALL_LOCATION', 'ONT_INSTALL_BASE')
1094: and enabled_flag = 'Y'

Line 1092: from OE_LOOKUPS

1088: DECODE(b.LOOKUP_CODE,NULL,
1089: c.ATTRIBUTE_STATUS||'029',c.ATTRIBUTE_STATUS)
1090: FROM -- OE_LOOKUPS b,
1091: ( select lookup_code, meaning
1092: from OE_LOOKUPS
1093: where lookup_type In ('ITEM_INSTALL_LOCATION', 'ONT_INSTALL_BASE')
1094: and enabled_flag = 'Y'
1095: and SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1096: AND NVL(END_DATE_ACTIVE, SYSDATE) ) b,

Line 1117: FROM -- OE_LOOKUPS b,

1113: (SELECT b.LOOKUP_CODE,
1114: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1115: DECODE(b.LOOKUP_CODE,NULL,
1116: c.ATTRIBUTE_STATUS||'030',c.ATTRIBUTE_STATUS)
1117: FROM -- OE_LOOKUPS b,
1118: ( select lookup_code, meaning
1119: from OE_LOOKUPS
1120: where lookup_type In ('ITEM_CURRENT_LOCATION', 'ONT_INSTALL_BASE')
1121: and enabled_flag = 'Y'

Line 1119: from OE_LOOKUPS

1115: DECODE(b.LOOKUP_CODE,NULL,
1116: c.ATTRIBUTE_STATUS||'030',c.ATTRIBUTE_STATUS)
1117: FROM -- OE_LOOKUPS b,
1118: ( select lookup_code, meaning
1119: from OE_LOOKUPS
1120: where lookup_type In ('ITEM_CURRENT_LOCATION', 'ONT_INSTALL_BASE')
1121: and enabled_flag = 'Y'
1122: and SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1123: AND NVL(END_DATE_ACTIVE, SYSDATE) ) b,

Line 1393: FROM OE_LOOKUPS b, OE_LINES_IFACE_ALL d

1389: (SELECT b.LOOKUP_CODE,
1390: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1391: DECODE(b.LOOKUP_CODE,NULL,
1392: c.ATTRIBUTE_STATUS||'011',c.ATTRIBUTE_STATUS)
1393: FROM OE_LOOKUPS b, OE_LINES_IFACE_ALL d
1394: WHERE d.FREIGHT_TERMS = b.MEANING(+)
1395: AND b.LOOKUP_TYPE(+) = 'FREIGHT_TERMS'
1396: AND b.enabled_flag(+) = 'Y'
1397: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1689: FROM OE_LOOKUPS b, OE_LINES_IFACE_ALL d

1685: (SELECT b.LOOKUP_CODE,
1686: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1687: DECODE(b.LOOKUP_CODE,NULL,
1688: c.ATTRIBUTE_STATUS||'023',c.ATTRIBUTE_STATUS)
1689: FROM OE_LOOKUPS b, OE_LINES_IFACE_ALL d
1690: WHERE d.SHIPMENT_PRIORITY = b.MEANING(+)
1691: AND b.LOOKUP_TYPE(+) = 'SHIPMENT_PRIORITY'
1692: AND b.enabled_flag(+) = 'Y'
1693: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)

Line 1870: FROM -- OE_LOOKUPS b,

1866: (SELECT b.LOOKUP_CODE,
1867: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1868: DECODE(b.LOOKUP_CODE,NULL,
1869: c.ATTRIBUTE_STATUS||'028',c.ATTRIBUTE_STATUS)
1870: FROM -- OE_LOOKUPS b,
1871: ( select lookup_code, meaning
1872: from OE_LOOKUPS
1873: where lookup_type In ('ITEM_OWNER', 'ONT_INSTALL_BASE')
1874: and enabled_flag = 'Y'

Line 1872: from OE_LOOKUPS

1868: DECODE(b.LOOKUP_CODE,NULL,
1869: c.ATTRIBUTE_STATUS||'028',c.ATTRIBUTE_STATUS)
1870: FROM -- OE_LOOKUPS b,
1871: ( select lookup_code, meaning
1872: from OE_LOOKUPS
1873: where lookup_type In ('ITEM_OWNER', 'ONT_INSTALL_BASE')
1874: and enabled_flag = 'Y'
1875: and SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1876: AND NVL(END_DATE_ACTIVE, SYSDATE) ) b,

Line 1901: FROM -- OE_LOOKUPS b,

1897: (SELECT b.LOOKUP_CODE,
1898: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1899: DECODE(b.LOOKUP_CODE,NULL,
1900: c.ATTRIBUTE_STATUS||'029',c.ATTRIBUTE_STATUS)
1901: FROM -- OE_LOOKUPS b,
1902: ( select lookup_code, meaning
1903: from OE_LOOKUPS
1904: where lookup_type In ('ITEM_INSTALL_LOCATION', 'ONT_INSTALL_BASE')
1905: and enabled_flag = 'Y'

Line 1903: from OE_LOOKUPS

1899: DECODE(b.LOOKUP_CODE,NULL,
1900: c.ATTRIBUTE_STATUS||'029',c.ATTRIBUTE_STATUS)
1901: FROM -- OE_LOOKUPS b,
1902: ( select lookup_code, meaning
1903: from OE_LOOKUPS
1904: where lookup_type In ('ITEM_INSTALL_LOCATION', 'ONT_INSTALL_BASE')
1905: and enabled_flag = 'Y'
1906: and SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1907: AND NVL(END_DATE_ACTIVE, SYSDATE) ) b,

Line 1931: FROM -- OE_LOOKUPS b,

1927: (SELECT b.LOOKUP_CODE,
1928: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1929: DECODE(b.LOOKUP_CODE,NULL,
1930: c.ATTRIBUTE_STATUS||'030',c.ATTRIBUTE_STATUS)
1931: FROM -- OE_LOOKUPS b,
1932: ( select lookup_code, meaning
1933: from OE_LOOKUPS
1934: where lookup_type In ('ITEM_CURRENT_LOCATION', 'ONT_INSTALL_BASE')
1935: and enabled_flag = 'Y'

Line 1933: from OE_LOOKUPS

1929: DECODE(b.LOOKUP_CODE,NULL,
1930: c.ATTRIBUTE_STATUS||'030',c.ATTRIBUTE_STATUS)
1931: FROM -- OE_LOOKUPS b,
1932: ( select lookup_code, meaning
1933: from OE_LOOKUPS
1934: where lookup_type In ('ITEM_CURRENT_LOCATION', 'ONT_INSTALL_BASE')
1935: and enabled_flag = 'Y'
1936: and SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1937: AND NVL(END_DATE_ACTIVE, SYSDATE) ) b,