DBA Data[Home] [Help]

APPS.OE_BULK_VALUE_TO_ID dependencies on OE_SHIP_METHODS_V

Line 889: FROM OE_SHIP_METHODS_V b, OE_HEADERS_IFACE_ALL d

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)

Line 1714: FROM OE_SHIP_METHODS_V b, OE_LINES_IFACE_ALL d

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)