DBA Data[Home] [Help]

APPS.OE_BULK_VALUE_TO_ID dependencies on OE_RA_TERMS_V

Line 554: FROM OE_RA_TERMS_V b, OE_HEADERS_IFACE_ALL d

550: (SELECT b.TERM_ID,
551: DECODE(b.TERM_ID,NULL,'Y',NULL),
552: DECODE(b.TERM_ID,NULL,
553: c.ATTRIBUTE_STATUS||'010',c.ATTRIBUTE_STATUS)
554: FROM OE_RA_TERMS_V b, OE_HEADERS_IFACE_ALL d
555: WHERE d.PAYMENT_TERM = b.NAME(+)
556: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
557: AND NVL(END_DATE_ACTIVE, SYSDATE)
558: AND d.rowid = c.rowid

Line 1371: FROM OE_RA_TERMS_V b, OE_LINES_IFACE_ALL d

1367: (SELECT b.TERM_ID,
1368: DECODE(b.TERM_ID,NULL,'Y',NULL),
1369: DECODE(b.TERM_ID,NULL,
1370: c.ATTRIBUTE_STATUS||'010',c.ATTRIBUTE_STATUS)
1371: FROM OE_RA_TERMS_V b, OE_LINES_IFACE_ALL d
1372: WHERE d.PAYMENT_TERM = b.NAME(+)
1373: AND SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE)
1374: AND NVL(END_DATE_ACTIVE, SYSDATE)
1375: AND d.rowid = c.rowid