FND Design Data [Home] [Help]

View: OKL_TXL_RCPT_APPS_V

Product: OKL - Lease and Finance Management
Description: Apply cash to various OKL objects
Implementation/DBA Data: ViewAPPS.OKL_TXL_RCPT_APPS_V
View Text

SELECT RCAB.ROWID ROW_ID
, RCAB.ID ID
, RCAB.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RCAT.SFWT_FLAG SFWT_FLAG
, RCAB.CNR_ID CNR_ID
, RCAB.LLN_ID LLN_ID
, RCAB.LSM_ID LSM_ID
, RCAB.KHR_ID KHR_ID
, RCAB.ILE_ID ILE_ID
, RCAB.STY_ID STY_ID
, RCAB.RCT_ID_DETAILS RCT_ID_DETAILS
, RCAB.LINE_NUMBER LINE_NUMBER
, RCAT.DESCRIPTION DESCRIPTION
, RCAB.AMOUNT AMOUNT
, RCAB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, RCAB.ATTRIBUTE1 ATTRIBUTE1
, RCAB.ATTRIBUTE2 ATTRIBUTE2
, RCAB.ATTRIBUTE3 ATTRIBUTE3
, RCAB.ATTRIBUTE4 ATTRIBUTE4
, RCAB.ATTRIBUTE5 ATTRIBUTE5
, RCAB.ATTRIBUTE6 ATTRIBUTE6
, RCAB.ATTRIBUTE7 ATTRIBUTE7
, RCAB.ATTRIBUTE8 ATTRIBUTE8
, RCAB.ATTRIBUTE9 ATTRIBUTE9
, RCAB.ATTRIBUTE10 ATTRIBUTE10
, RCAB.ATTRIBUTE11 ATTRIBUTE11
, RCAB.ATTRIBUTE12 ATTRIBUTE12
, RCAB.ATTRIBUTE13 ATTRIBUTE13
, RCAB.ATTRIBUTE14 ATTRIBUTE14
, RCAB.ATTRIBUTE15 ATTRIBUTE15
, RCAB.REQUEST_ID REQUEST_ID
, RCAB.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, RCAB.PROGRAM_ID PROGRAM_ID
, RCAB.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, RCAB.ORG_ID ORG_ID
, RCAB.CREATED_BY CREATED_BY
, RCAB.CREATION_DATE CREATION_DATE
, RCAB.LAST_UPDATED_BY LAST_UPDATED_BY
, RCAB.LAST_UPDATE_DATE LAST_UPDATE_DATE
, RCAB.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RCAB.AR_INVOICE_ID AR_INVOICE_ID
FROM OKL_TXL_RCPT_APPS_B RCAB
, OKL_TXL_RCPT_APPS_TL RCAT
WHERE RCAB.ID = RCAT.ID
AND RCAT.LANGUAGE = USERENV('LANG')

Columns

Name
ROW_ID
ID
OBJECT_VERSION_NUMBER
SFWT_FLAG
CNR_ID
LLN_ID
LSM_ID
KHR_ID
ILE_ID
STY_ID
RCT_ID_DETAILS
LINE_NUMBER
DESCRIPTION
AMOUNT
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
REQUEST_ID
PROGRAM_APPLICATION_ID
PROGRAM_ID
PROGRAM_UPDATE_DATE
ORG_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
AR_INVOICE_ID