AR_CONS_BILLING_TERMS_V

Details

• Schema: FUSION

• Object owner: AR

• Object type: VIEW

Columns

Name

CONS_BILLING_TERM_ID ENABLED_FLAG CONS_BILLING_METHOD_CODE CONS_BILLING_CYCLE_ID LAST_UPDATED_BY LAST_UPDATE_DATE CREATION_DATE CREATED_BY LAST_UPDATE_LOGIN ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 ATTRIBUTE_NUMBER1 ATTRIBUTE_NUMBER2 ATTRIBUTE_NUMBER3 ATTRIBUTE_NUMBER4 ATTRIBUTE_NUMBER5 ATTRIBUTE_DATE1 ATTRIBUTE_DATE2 ATTRIBUTE_DATE3 ATTRIBUTE_DATE4 ATTRIBUTE_DATE5 NAME DESCRIPTION

Query

SQL_Statement

SELECT b.cons_billing_term_id, b.enabled_flag, b.cons_billing_method_code, b.cons_billing_cycle_id, b.last_updated_by, b.last_update_date, b.creation_date, b.created_by, b.last_update_login, b.attribute_category, b.attribute1, b.attribute2, b.attribute3, b.attribute4, b.attribute5, b.attribute6, b.attribute7, b.attribute8, b.attribute9, b.attribute10, b.attribute11, b.attribute12, b.attribute13, b.attribute14, b.attribute15, b.attribute_number1, b.attribute_number2, b.attribute_number3, b.attribute_number4, b.attribute_number5, b.attribute_date1, b.attribute_date2, b.attribute_date3, b.attribute_date4, b.attribute_date5, t.name, t.description FROM ar_cons_billing_terms_tl t, ar_cons_billing_terms_b b WHERE b.cons_billing_term_id = t.cons_billing_term_id AND t.language = userenv('LANG')