DBA Data[Home] [Help]

APPS.OE_BULK_VALUE_TO_ID dependencies on OE_AGREEMENTS_V

Line 498: FROM OE_AGREEMENTS_V b, OE_HEADERS_IFACE_ALL d

494: (SELECT b.AGREEMENT_ID,
495: DECODE(b.AGREEMENT_ID,NULL,'Y',NULL),
496: DECODE(b.AGREEMENT_ID,NULL,
497: c.ATTRIBUTE_STATUS||'007',c.ATTRIBUTE_STATUS)
498: FROM OE_AGREEMENTS_V b, OE_HEADERS_IFACE_ALL d
499: WHERE d.AGREEMENT = b.NAME(+)
500: AND sysdate between nvl(start_date_active, sysdate)
501: and nvl(end_date_active, sysdate)
502: AND d.rowid = c.rowid

Line 1306: FROM OE_AGREEMENTS_V b, OE_LINES_IFACE_ALL d

1302: (SELECT b.AGREEMENT_ID,
1303: DECODE(b.AGREEMENT_ID,NULL,'Y',NULL),
1304: DECODE(b.AGREEMENT_ID,NULL,
1305: c.ATTRIBUTE_STATUS||'007',c.ATTRIBUTE_STATUS)
1306: FROM OE_AGREEMENTS_V b, OE_LINES_IFACE_ALL d
1307: WHERE d.AGREEMENT = b.NAME(+)
1308: AND sysdate between nvl(start_date_active, sysdate)
1309: and nvl(end_date_active, sysdate)
1310: AND d.rowid = c.rowid