DBA Data[Home] [Help]

APPS.OE_BULK_VALUE_TO_ID dependencies on RA_SALESREPS

Line 446: FROM RA_SALESREPS b, OE_HEADERS_IFACE_ALL d

442: (SELECT /*+ PUSH_PRED(b) */ b.SALESREP_ID,
443: DECODE(b.SALESREP_ID,NULL,'Y',NULL),
444: DECODE(b.SALESREP_ID,NULL,
445: c.ATTRIBUTE_STATUS||'005',c.ATTRIBUTE_STATUS)
446: FROM RA_SALESREPS b, OE_HEADERS_IFACE_ALL d
447: WHERE d.SALESREP = b.NAME(+)
448: AND sysdate between NVL(start_date_active,sysdate)
449: and NVL(end_date_active,sysdate)
450: AND d.rowid = c.rowid

Line 1238: FROM RA_SALESREPS b, OE_LINES_IFACE_ALL d

1234: (SELECT /*+ PUSH_PRED(b) */ b.SALESREP_ID,
1235: DECODE(b.SALESREP_ID,NULL,'Y',NULL),
1236: DECODE(b.SALESREP_ID,NULL,
1237: c.ATTRIBUTE_STATUS||'005',c.ATTRIBUTE_STATUS)
1238: FROM RA_SALESREPS b, OE_LINES_IFACE_ALL d
1239: WHERE d.SALESREP = b.NAME(+)
1240: AND sysdate between NVL(start_date_active,sysdate)
1241: and NVL(end_date_active,sysdate)
1242: AND d.rowid = c.rowid