View: OKL_EXT_CSH_RCPTS_V

Product:	OKL - Lease and Finance Management
Description:	A receipt received from a customer and send to Receivables lockbox interface
Implementation/DBA Data:	APPS.OKL_EXT_CSH_RCPTS_V

View Text

SELECT XCRB.ROWID ROW_ID
, XCRB.ID ID
, XCRB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, XCRT.SFWT_FLAG SFWT_FLAG
, XCRB.XCB_ID XCB_ID
, XCRB.RCT_ID RCT_ID
, XCRB.ICR_ID ICR_ID
, XCRB.ITEM_NUMBER ITEM_NUMBER
, XCRB.REMITTANCE_AMOUNT REMITTANCE_AMOUNT
, XCRB.CURRENCY_CODE CURRENCY_CODE
, XCRB.RECEIPT_DATE RECEIPT_DATE
, XCRB.RECEIPT_METHOD RECEIPT_METHOD
, XCRB.CHECK_NUMBER CHECK_NUMBER
, XCRT.COMMENTS COMMENTS
, XCRB.CUSTOMER_NUMBER CUSTOMER_NUMBER
, XCRB.BILL_TO_LOCATION BILL_TO_LOCATION
, XCRB.EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, XCRB.EXCHANGE_RATE EXCHANGE_RATE
, XCRB.EXCHANGE_RATE_DATE EXCHANGE_RATE_DATE
, XCRB.GL_DATE GL_DATE
, XCRB.TRANSIT_ROUTING_NUMBER TRANSIT_ROUTING_NUMBER
, XCRB.ACCOUNT ACCOUNT
, XCRB.CUSTOMER_BANK_NAME CUSTOMER_BANK_NAME
, XCRB.CUSTOMER_BANK_BRANCH_NAME CUSTOMER_BANK_BRANCH_NAME
, XCRB.REMITTANCE_BANK_NAME REMITTANCE_BANK_NAME
, XCRB.REMITTANCE_BANK_BRANCH_NAME REMITTANCE_BANK_BRANCH_NAME
, XCRB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, XCRB.RECEIPT_TYPE RECEIPT_TYPE
, XCRB.FULLY_APPLIED_FLAG FULLY_APPLIED_FLAG
, XCRB.EXPIRED_FLAG EXPIRED_FLAG
, XCRB.ATTRIBUTE1 ATTRIBUTE1
, XCRB.ATTRIBUTE2 ATTRIBUTE2
, XCRB.ATTRIBUTE3 ATTRIBUTE3
, XCRB.ATTRIBUTE4 ATTRIBUTE4
, XCRB.ATTRIBUTE5 ATTRIBUTE5
, XCRB.ATTRIBUTE6 ATTRIBUTE6
, XCRB.ATTRIBUTE7 ATTRIBUTE7
, XCRB.ATTRIBUTE8 ATTRIBUTE8
, XCRB.ATTRIBUTE9 ATTRIBUTE9
, XCRB.ATTRIBUTE10 ATTRIBUTE10
, XCRB.ATTRIBUTE11 ATTRIBUTE11
, XCRB.ATTRIBUTE12 ATTRIBUTE12
, XCRB.ATTRIBUTE13 ATTRIBUTE13
, XCRB.ATTRIBUTE14 ATTRIBUTE14
, XCRB.ATTRIBUTE15 ATTRIBUTE15
, XCRB.REQUEST_ID REQUEST_ID
, XCRB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, XCRB.PROGRAM_ID PROGRAM_ID
, XCRB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, XCRB.ORG_ID ORG_ID
, XCRB.CREATED_BY CREATED_BY
, XCRB.CREATION_DATE CREATION_DATE
, XCRB.LAST_UPDATED_BY LAST_UPDATED_BY
, XCRB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, XCRB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM OKL_EXT_CSH_RCPTS_B XCRB
, OKL_EXT_CSH_RCPTS_TL XCRT
WHERE XCRB.ID = XCRT.ID
AND XCRT.LANGUAGE = USERENV('LANG')

Columns