VIEW: APPS.RA_TERMS_VL

Source

View Text - Preformatted

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(+)

View Text - HTML Formatted

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(+)