APPS.OE_BULK_VALUE_TO_ID dependencies on OE_RA_RULES_V

Line 518: FROM OE_RA_RULES_V b, OE_HEADERS_IFACE_ALL d

514: (SELECT b.RULE_ID,
515: DECODE(b.RULE_ID,NULL,'Y',NULL),
516: DECODE(b.RULE_ID,NULL,
517: c.ATTRIBUTE_STATUS||'008',c.ATTRIBUTE_STATUS)
518: FROM OE_RA_RULES_V b, OE_HEADERS_IFACE_ALL d
519: WHERE d.INVOICING_RULE = b.NAME(+)
520: AND b.STATUS(+) = 'A'
521: AND b.TYPE(+) = 'I'
522: AND d.rowid = c.rowid

Line 536: FROM OE_RA_RULES_V b, OE_HEADERS_IFACE_ALL d

532: (SELECT b.RULE_ID,
533: DECODE(b.RULE_ID,NULL,'Y',NULL),
534: DECODE(b.RULE_ID,NULL,
535: c.ATTRIBUTE_STATUS||'009',c.ATTRIBUTE_STATUS)
536: FROM OE_RA_RULES_V b, OE_HEADERS_IFACE_ALL d
537: WHERE d.ACCOUNTING_RULE = b.NAME(+)
538: AND b.STATUS(+) = 'A'
539: -- AND b.TYPE(+) = 'A' --we now allow variable accounting rules
540: AND d.rowid = c.rowid

Line 1329: FROM OE_RA_RULES_V b, OE_LINES_IFACE_ALL d

1325: (SELECT b.RULE_ID,
1326: DECODE(b.RULE_ID,NULL,'Y',NULL),
1327: DECODE(b.RULE_ID,NULL,
1328: c.ATTRIBUTE_STATUS||'008',c.ATTRIBUTE_STATUS)
1329: FROM OE_RA_RULES_V b, OE_LINES_IFACE_ALL d
1330: WHERE d.INVOICING_RULE = b.NAME(+)
1331: AND b.STATUS(+) = 'A'
1332: AND b.TYPE(+) = 'I'
1333: AND d.rowid = c.rowid

Line 1350: FROM OE_RA_RULES_V b, OE_LINES_IFACE_ALL d

1346: (SELECT b.RULE_ID,
1347: DECODE(b.RULE_ID,NULL,'Y',NULL),
1348: DECODE(b.RULE_ID,NULL,
1349: c.ATTRIBUTE_STATUS||'009',c.ATTRIBUTE_STATUS)
1350: FROM OE_RA_RULES_V b, OE_LINES_IFACE_ALL d
1351: WHERE d.ACCOUNTING_RULE = b.NAME(+)
1352: AND b.STATUS(+) = 'A'
1353: -- AND b.TYPE(+) = 'A' --we now allow variable accounting rules
1354: AND d.rowid = c.rowid