View: RA_TERMS_VL

Product:	AR - Receivables
Description:	(Release 11.5 and Release 12.0)
Implementation/DBA Data:	APPS.RA_TERMS_VL

View Text

SELECT B.ROWID ROW_ID
, B.TERM_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.CREDIT_CHECK_FLAG
, B.DUE_CUTOFF_DAY
, B.PRINTING_LEAD_DAYS
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.BASE_AMOUNT
, B.CALC_DISCOUNT_ON_LINES_FLAG
, B.FIRST_INSTALLMENT_CODE
, B.IN_USE
, B.PARTIAL_DISCOUNT_FLAG
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, T.NAME
, T.DESCRIPTION
, NVL(B.PREPAYMENT_FLAG
, 'N')
, B.BILLING_CYCLE_ID
, BC.CYCLE_NAME
FROM RA_TERMS_TL T
, RA_TERMS_B B
, AR_CONS_BILL_CYCLES_TL BC
WHERE B.TERM_ID = T.TERM_ID
AND B.BILLING_CYCLE_ID = BC.BILLING_CYCLE_ID(+)
AND T.LANGUAGE = USERENV('LANG')
AND USERENV('LANG') = BC.LANGUAGE(+)

Columns