eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.OKL_ACC_TRX_TYPES_UV

Object Details

Object Name:	OKL_ACC_TRX_TYPES_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_ACC_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	Column used for locking records during updates
SFWT_FLAG	VARCHAR2	(3)	Yes	Indicates a value was changed in another language.
AEP_CODE	VARCHAR2	(30)		Accounting Event Code
ILC_ID	NUMBER		Yes	Application id. It is defaulted to 540
TRY_ID	NUMBER			Foreign key to table OKL_TRX_TYPES_B
TRY_ID_FOR	NUMBER			Transaction type id.
TRY_TYPE	VARCHAR2	(30)	Yes	Transaction Type Category
NAME	VARCHAR2	(150)	Yes	Transaction type name
DESCRIPTION	VARCHAR2	(1995)		Brief description about the transaction type
CONTRACT_HEADER_LINE_FLAG	VARCHAR2	(3)	Yes	Not used
TRANSACTION_HEADER_LINE_DETAIL	VARCHAR2	(3)	Yes	Not used
TRX_TYPE_CLASS	VARCHAR2	(30)	Yes	Transaction type class. Points to FND lookup OKL_TRANSACTION_TYPE_CLASS
ORG_ID	NUMBER	(15)		Operating unit identifier
CREATED_BY	NUMBER	(15)	Yes	Standard who column
CREATION_DATE	DATE		Yes	Standard who column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard who column
LAST_UPDATE_DATE	DATE		Yes	Standard who column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard who column

Query Text

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


SELECT ID
,      OBJECT_VERSION_NUMBER
,      SFWT_FLAG
,      AEP_CODE
,      ILC_ID
,      TRY_ID
,      TRY_ID_FOR
,      TRY_TYPE
,      NAME
,      DESCRIPTION
,      CONTRACT_HEADER_LINE_FLAG
,      TRANSACTION_HEADER_LINE_DETAIL
,      TRX_TYPE_CLASS
,      ORG_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKL_ACC_TRX_TYPES_UV;

Dependencies

[top of page]

APPS.OKL_ACC_TRX_TYPES_UV references the following:

APPS: OKL_TRX_TYPES_V

APPS.OKL_ACC_TRX_TYPES_UV is not referenced by any database object