885: (SELECT b.LOOKUP_CODE,
886: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
887: DECODE(b.LOOKUP_CODE,NULL,
888: c.ATTRIBUTE_STATUS||'024',c.ATTRIBUTE_STATUS)
889: FROM OE_SHIP_METHODS_V b, OE_HEADERS_IFACE_ALL d
890: WHERE d.SHIPPING_METHOD = b.MEANING(+)
891: AND b.enabled_flag(+) = 'Y'
892: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE(+), SYSDATE)
893: AND NVL(END_DATE_ACTIVE(+), SYSDATE)
1710: (SELECT b.LOOKUP_CODE,
1711: DECODE(b.LOOKUP_CODE,NULL,'Y',NULL),
1712: DECODE(b.LOOKUP_CODE,NULL,
1713: c.ATTRIBUTE_STATUS||'024',c.ATTRIBUTE_STATUS)
1714: FROM OE_SHIP_METHODS_V b, OE_LINES_IFACE_ALL d
1715: WHERE d.SHIPPING_METHOD = b.MEANING(+)
1716: AND b.enabled_flag(+) = 'Y'
1717: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1718: AND NVL(END_DATE_ACTIVE, SYSDATE)