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_TRX_HEADER_UV

Object Details

Object Name:	OKL_TRX_HEADER_UV
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_TRX_HEADER_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	Comments
ID	VARCHAR2	(72)
TRANS_ID	VARCHAR2	(40)	Transaction Identifier
KHR_ID	NUMBER		Contract Identifier
CONTRACT_NUMBER	VARCHAR2	(120)
SOURCE_CODE	VARCHAR2	(5)
SOURCE	VARCHAR2	(4000)
TRANSACTION_NUMBER	VARCHAR2	(56)
TRANSACTION_TYPE	VARCHAR2	(4000)
TRANSACTION_STATUS	VARCHAR2	(4000)
TRANSACTION_DATE	DATE
DESCRIPTION	VARCHAR2	(4000)
PRODUCT_NAME	VARCHAR2	(150)	Not used
AMOUNT	NUMBER
CURRENCY_CODE	VARCHAR2	(4000)
ACTUAL_DRAFT_STATUS_CODE	VARCHAR2	(4000)	Actual or Draft Status Code
ACTUAL_DRAFT_STATUS	VARCHAR2	(4000)	Actual Draft Status
TOTAL_TRANSACTION_AMOUNT	NUMBER
CHECK_ID	VARCHAR2	(0)
ORG_ID	NUMBER		Operating Unit Identifier
REPRESENTATION_CODE	VARCHAR2	(20)	Representation Code
VENDOR_ID	NUMBER		Vendor Identifier
ACCOUNT_NUMBER	VARCHAR2	(30)	Account Number
CONLS_INV_ID	VARCHAR2	(150)	Consolidated Invoice Identifier
BOOK_TYPE_CODE	VARCHAR2	(15)	Book Type Code
PERIOD_COUNTER	NUMBER		Period Counter
DEPRN_RUN_ID	NUMBER		Depreciation Run Identifier
TRY_ID	NUMBER		Transaction Type Identifier
INVOICE_YN	CHAR	(1)	Invoice Yes No Indicator

Query Text

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


SELECT ID
,      TRANS_ID
,      KHR_ID
,      CONTRACT_NUMBER
,      SOURCE_CODE
,      SOURCE
,      TRANSACTION_NUMBER
,      TRANSACTION_TYPE
,      TRANSACTION_STATUS
,      TRANSACTION_DATE
,      DESCRIPTION
,      PRODUCT_NAME
,      AMOUNT
,      CURRENCY_CODE
,      ACTUAL_DRAFT_STATUS_CODE
,      ACTUAL_DRAFT_STATUS
,      TOTAL_TRANSACTION_AMOUNT
,      CHECK_ID
,      ORG_ID
,      REPRESENTATION_CODE
,      VENDOR_ID
,      ACCOUNT_NUMBER
,      CONLS_INV_ID
,      BOOK_TYPE_CODE
,      PERIOD_COUNTER
,      DEPRN_RUN_ID
,      TRY_ID
,      INVOICE_YN
FROM APPS.OKL_TRX_HEADER_UV;

Dependencies

[top of page]

APPS.OKL_TRX_HEADER_UV references the following:

APPS: AP_INVOICES_PKG - show dependent code; ARPT_SQL_FUNC_UTIL - show dependent code; FA_ADDITIONS; FA_BOOK_CONTROLS; FA_CATEGORIES_B_KFV; FA_DEPRN_PERIODS; FA_DEPRN_SUMMARY; FA_LOOKUPS; FA_TRANSACTION_HEADERS; FND_ATTACHMENT_UTIL_PKG - show dependent code; GL_LEDGERS; OKC_K_HEADERS_B; OKL_ACCOUNTING_UTIL - show dependent code; OKL_BILLING_UTIL_PVT - show dependent code; OKL_BPD_AP_INVOICE_UV; OKL_BPD_AR_ADJUSTMENTS_V; OKL_BPD_AR_HEADER_V; OKL_BPD_TRX_RCPT_HEADER_V; OKL_SYSTEM_PARAMS; OKL_SYS_ACCT_OPTS; OKL_TAX_BK_TRX_ASSTS_V; OKL_TRX_ASSETS; OKL_TRX_CONTRACTS_ALL; OKL_TRX_TYPES_V; OKL_TXL_ASSETS_B; OKL_TXL_CNTRCT_LNS_UV; OKL_VIEW_TRX_ASSETS_V

APPS.OKL_TRX_HEADER_UV is not referenced by any database object