View: OKL_BILLING_CHARGES_V

Product:	OKL - Lease and Finance Management
Description:	Billing import mechanism within OKL provides an ability to read third-party files containing billing charges
Implementation/DBA Data:	APPS.OKL_BILLING_CHARGES_V

View Text

SELECT BCHB.ROWID ROW_ID
, BCHB.ID ID
, BCHB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, BCHT.SFWT_FLAG SFWT_FLAG
, BCHB.BGH_ID BGH_ID
, BCHB.STY_ID STY_ID
, BCHB.STY_NAME STY_NAME
, BCHB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, BCHB.CONTRACT_ID CONTRACT_ID
, BCHB.ASSET_ID ASSET_ID
, BCHT.CHARGE_TYPE CHARGE_TYPE
, BCHB.CHARGE_DATE CHARGE_DATE
, BCHB.AMOUNT AMOUNT
, BCHB.CURRENCY_CODE CURRENCY_CODE
, BCHT.DESCRIPTION DESCRIPTION
, BCHB.CUSTOMER_ID CUSTOMER_ID
, BCHB.CUSTOMER_REF CUSTOMER_REF
, BCHB.CUSTOMER_ADDRESS_ID CUSTOMER_ADDRESS_ID
, BCHB.CUSTOMER_ADDRESS_REF CUSTOMER_ADDRESS_REF
, BCHB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, BCHB.ATTRIBUTE1 ATTRIBUTE1
, BCHB.ATTRIBUTE2 ATTRIBUTE2
, BCHB.ATTRIBUTE3 ATTRIBUTE3
, BCHB.ATTRIBUTE4 ATTRIBUTE4
, BCHB.ATTRIBUTE5 ATTRIBUTE5
, BCHB.ATTRIBUTE6 ATTRIBUTE6
, BCHB.ATTRIBUTE7 ATTRIBUTE7
, BCHB.ATTRIBUTE8 ATTRIBUTE8
, BCHB.ATTRIBUTE9 ATTRIBUTE9
, BCHB.ATTRIBUTE10 ATTRIBUTE10
, BCHB.ATTRIBUTE11 ATTRIBUTE11
, BCHB.ATTRIBUTE12 ATTRIBUTE12
, BCHB.ATTRIBUTE13 ATTRIBUTE13
, BCHB.ATTRIBUTE14 ATTRIBUTE14
, BCHB.ATTRIBUTE15 ATTRIBUTE15
, BCHB.REQUEST_ID REQUEST_ID
, BCHB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, BCHB.PROGRAM_ID PROGRAM_ID
, BCHB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, BCHB.ORG_ID ORG_ID
, BCHB.CREATED_BY CREATED_BY
, BCHB.CREATION_DATE CREATION_DATE
, BCHB.LAST_UPDATED_BY LAST_UPDATED_BY
, BCHB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, BCHB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, BCHB.INTERFACE_ATTRIBUTE1 INTERFACE_ATTRIBUTE1
, BCHB.INTERFACE_ATTRIBUTE2 INTERFACE_ATTRIBUTE2
, BCHB.INTERFACE_ATTRIBUTE3 INTERFACE_ATTRIBUTE3
, BCHB.INTERFACE_ATTRIBUTE4 INTERFACE_ATTRIBUTE4
, BCHB.INTERFACE_ATTRIBUTE5 INTERFACE_ATTRIBUTE5
, BCHB.INTERFACE_ATTRIBUTE6 INTERFACE_ATTRIBUTE6
, BCHB.INTERFACE_ATTRIBUTE7 INTERFACE_ATTRIBUTE7
, BCHB.INTERFACE_ATTRIBUTE8 INTERFACE_ATTRIBUTE8
, BCHB.INTERFACE_ATTRIBUTE9 INTERFACE_ATTRIBUTE9
, BCHB.INTERFACE_ATTRIBUTE10 INTERFACE_ATTRIBUTE10
, BCHB.INTERFACE_ATTRIBUTE11 INTERFACE_ATTRIBUTE11
, BCHB.INTERFACE_ATTRIBUTE12 INTERFACE_ATTRIBUTE12
, BCHB.INTERFACE_ATTRIBUTE13 INTERFACE_ATTRIBUTE13
, BCHB.INTERFACE_ATTRIBUTE14 INTERFACE_ATTRIBUTE14
, BCHB.INTERFACE_ATTRIBUTE15 INTERFACE_ATTRIBUTE15
FROM OKL_BILLING_CHARGES_B BCHB
, OKL_BILLING_CHARGES_TL BCHT
WHERE BCHB.ID = BCHT.ID
AND BCHT.LANGUAGE = USERENV('LANG')

Columns