DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.OKL_AR_REC_APP_REF_VL

Object Details
Object Name: OKL_AR_REC_APP_REF_VL
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKL.OKL_AR_REC_APP_REF_VL
Subobject Name:
Status: VALID

View Type

MultiLingual view (a language resolved view of the data.)

[View Source]

Columns
Name Datatype Length Mandatory Comments
OKL_REC_APP_ID NUMBER (15) Yes Identifies the receivable application
OKL_TXD_ID NUMBER
Yes Source Table Identifier
OKL_LANGUAGE VARCHAR2 (12) Yes Language
OKL_CONTRACT_STATUS VARCHAR2 (90)
Contract Status
OKL_INV_AGRMNT_STATUS VARCHAR2 (90)
Investor Agreement Status
OKL_STREAM_TYPE_NAME VARCHAR2 (150)
Transaction Line Stream Type Name
OKL_TRANSACTION_TYPE_NAME VARCHAR2 (150)
Transaction Type Name
OKL_TRANS_LINE_DESCRIPTION VARCHAR2 (1995)
Transaction Line Description
OKL_INVENTORY_ORG_NAME VARCHAR2 (240)
Contract Inventory Organization Name
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT OKL_REC_APP_ID
,      OKL_TXD_ID
,      OKL_LANGUAGE
,      OKL_CONTRACT_STATUS
,      OKL_INV_AGRMNT_STATUS
,      OKL_STREAM_TYPE_NAME
,      OKL_TRANSACTION_TYPE_NAME
,      OKL_TRANS_LINE_DESCRIPTION
,      OKL_INVENTORY_ORG_NAME
FROM APPS.OKL_AR_REC_APP_REF_VL;

Dependencies

[top of page]

APPS.OKL_AR_REC_APP_REF_VL references the following:

SchemaAPPS
SynonymAR_ACTIVITY_DETAILS
SynonymAR_RECEIVABLE_APPLICATIONS_ALL
SynonymOKL_EXT_AR_HEADER_SOURCES_B
SynonymOKL_EXT_AR_HEADER_SOURCES_TL
SynonymOKL_EXT_AR_LINE_SOURCES_B
SynonymOKL_EXT_AR_LINE_SOURCES_TL
SynonymRA_CUSTOMER_TRX_LINES_ALL
APPS.OKL_AR_REC_APP_REF_VL is referenced by following:

SchemaAPPS
ViewOKL_AR_RECEIVABLE_APPS_L_V