DBA Data[Home] [Help]

APPS.OE_BULK_VALUE_TO_ID dependencies on OE_ORDER_TYPES_V

Line 393: FROM OE_ORDER_TYPES_V b, OE_HEADERS_IFACE_ALL d

389: (SELECT b.ORDER_TYPE_ID,
390: DECODE(b.ORDER_TYPE_ID,NULL,'Y',NULL),
391: DECODE(b.ORDER_TYPE_ID,NULL,
392: c.ATTRIBUTE_STATUS||'002',c.ATTRIBUTE_STATUS)
393: FROM OE_ORDER_TYPES_V b, OE_HEADERS_IFACE_ALL d
394: WHERE d.order_type = b.name(+)
395: AND d.rowid = c.rowid
396: )
397: WHERE c.batch_id = p_batch_id