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


VIEW: APPS.OKL_TRX_TYPES_UV

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ID NUMBER
Yes
OBJECT_VERSION_NUMBER NUMBER (9) Yes
SFWT_FLAG VARCHAR2 (3) Yes
AEP_CODE VARCHAR2 (30)
AEP_CODE_DESC VARCHAR2 (4000)
ILC_ID NUMBER
Yes
TRY_ID NUMBER

Foreign key to view OKL_TRX_TYPES_V
TRY_ID_NAME VARCHAR2 (0)
TRY_ID_FOR NUMBER

TRY_ID_FOR_NAME VARCHAR2 (0)
TRY_TYPE VARCHAR2 (30) Yes
TRY_TYPE_DESC VARCHAR2 (4000)
NAME VARCHAR2 (150) Yes
DESCRIPTION VARCHAR2 (1995)
CONTRACT_HEADER_LINE_FLAG VARCHAR2 (3) Yes
TRANSACTION_HEADER_LINE_DETAIL VARCHAR2 (3) Yes
TRX_TYPE_CLASS VARCHAR2 (30) Yes
TRX_TYPE_CLASS_DESC VARCHAR2 (4000)
ORG_ID NUMBER (15)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
Query Text

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


SELECT ID
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      AEP_CODE
,      AEP_CODE_DESC
,      ILC_ID
,      TRY_ID
,      TRY_ID_NAME
,      TRY_ID_FOR
,      TRY_ID_FOR_NAME
,      TRY_TYPE
,      TRY_TYPE_DESC
,      NAME
,      DESCRIPTION
,      CONTRACT_HEADER_LINE_FLAG
,      TRANSACTION_HEADER_LINE_DETAIL
,      TRX_TYPE_CLASS
,      TRX_TYPE_CLASS_DESC
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKL_TRX_TYPES_UV;

Dependencies

[top of page]

APPS.OKL_TRX_TYPES_UV references the following:

SchemaAPPS
PL/SQL PackageOKL_ACCOUNTING_UTIL - show dependent code
SynonymOKL_TRX_TYPES_B
SynonymOKL_TRX_TYPES_TL

APPS.OKL_TRX_TYPES_UV is not referenced by any database object