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_CMN_EXTRACT_HDR_V

Object Details

Object Name:	OKL_CMN_EXTRACT_HDR_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_CMN_EXTRACT_HDR_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EVENT_ID	NUMBER	(15)
TEH_CONTRACT_NUMBER	VARCHAR2	(120)
TCN_REPRESENTATION_CODE	VARCHAR2	(20)
TCN_REPRESENTATION_NAME	VARCHAR2	(30)
TEH_RENT_IA_CONTRACT_NUMBER	VARCHAR2	(120)
TEH_RES_IA_CONTRACT_NUMBER	VARCHAR2	(120)
TEH_CONVERTED_NUMBER	VARCHAR2	(30)
TEH_CONTRACT_EFFECTIVE_FROM	DATE
TCN_BOOK_CLASSIFICATION_CODE	VARCHAR2	(30)
TCN_CONTRACT_PRODUCT_NAME	VARCHAR2	(150)
TEH_RENT_IA_PRODUCT_NAME	VARCHAR2	(150)
TEH_RES_IA_PRODUCT_NAME	VARCHAR2	(150)
TEH_REV_REC_METHOD_CODE	VARCHAR2	(150)
TEH_INT_CALC_METHOD_CODE	VARCHAR2	(150)
TCN_TAX_OWNER_CODE	VARCHAR2	(150)
TEH_CONTRACT_CURRENCY_CODE	VARCHAR2	(80)
TEH_SALES_REP_NAME	VARCHAR2	(240)
TCN_AMOUNT	NUMBER
TCN_CURR_CONVERSION_DATE	DATE
TCN_CURR_CONVERSION_RATE	NUMBER
TCN_CURR_CONVERSION_TYPE	VARCHAR2	(30)
TEH_CUSTOMER_NAME	VARCHAR2	(360)
TEH_CUSTOMER_ACCOUNT_NUMBER	VARCHAR2	(30)
TEH_BILL_TO_ADDRESS_NUM	NUMBER
TEH_PO_ORDER_NUMBER	VARCHAR2	(150)
TEH_VENDOR_PROGRAM_NUMBER	VARCHAR2	(120)
TCN_DATE_TRANSACTION_OCCURRED	DATE		Yes
TCN_TRX_NUMBER	VARCHAR2	(30)	Yes
TEH_RENT_IA_ACCOUNTING_CODE	VARCHAR2	(450)
TEH_RES_IA_ACCOUNTING_CODE	VARCHAR2	(450)
TEH_ASSIGNABLE_FLAG	VARCHAR2	(3)
TEH_CONVERTED_ACCOUNT_FLAG	VARCHAR2	(3)
TEH_ACCRUAL_OVERRIDE_FLAG	VARCHAR2	(3)
TCN_CURRENCY_CODE	VARCHAR2	(150)
TCN_ID	NUMBER		Yes
TCN_STATUS_CODE	VARCHAR2	(30)
TCN_TYPE	VARCHAR2	(10)	Yes
TCN_ACCOUNTING_REVERSAL_FLAG	VARCHAR2	(3)
GL_DATE	DATE
TCN_ORG_ID	NUMBER	(15)
TEH_CONTRACT_STATUS_CODE	VARCHAR2	(90)		Contract Status Code
TEH_TRX_TYPE_CLASS_CODE	VARCHAR2	(90)		Transaction Type Class Code
TEH_CHR_OPERATING_UNIT_CODE	VARCHAR2	(240)		Contract Operating Unit Code
TCN_REPRESENTATION_TYPE	VARCHAR2	(9)

Query Text

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


SELECT EVENT_ID
,      TEH_CONTRACT_NUMBER
,      TCN_REPRESENTATION_CODE
,      TCN_REPRESENTATION_NAME
,      TEH_RENT_IA_CONTRACT_NUMBER
,      TEH_RES_IA_CONTRACT_NUMBER
,      TEH_CONVERTED_NUMBER
,      TEH_CONTRACT_EFFECTIVE_FROM
,      TCN_BOOK_CLASSIFICATION_CODE
,      TCN_CONTRACT_PRODUCT_NAME
,      TEH_RENT_IA_PRODUCT_NAME
,      TEH_RES_IA_PRODUCT_NAME
,      TEH_REV_REC_METHOD_CODE
,      TEH_INT_CALC_METHOD_CODE
,      TCN_TAX_OWNER_CODE
,      TEH_CONTRACT_CURRENCY_CODE
,      TEH_SALES_REP_NAME
,      TCN_AMOUNT
,      TCN_CURR_CONVERSION_DATE
,      TCN_CURR_CONVERSION_RATE
,      TCN_CURR_CONVERSION_TYPE
,      TEH_CUSTOMER_NAME
,      TEH_CUSTOMER_ACCOUNT_NUMBER
,      TEH_BILL_TO_ADDRESS_NUM
,      TEH_PO_ORDER_NUMBER
,      TEH_VENDOR_PROGRAM_NUMBER
,      TCN_DATE_TRANSACTION_OCCURRED
,      TCN_TRX_NUMBER
,      TEH_RENT_IA_ACCOUNTING_CODE
,      TEH_RES_IA_ACCOUNTING_CODE
,      TEH_ASSIGNABLE_FLAG
,      TEH_CONVERTED_ACCOUNT_FLAG
,      TEH_ACCRUAL_OVERRIDE_FLAG
,      TCN_CURRENCY_CODE
,      TCN_ID
,      TCN_STATUS_CODE
,      TCN_TYPE
,      TCN_ACCOUNTING_REVERSAL_FLAG
,      GL_DATE
,      TCN_ORG_ID
,      TEH_CONTRACT_STATUS_CODE
,      TEH_TRX_TYPE_CLASS_CODE
,      TEH_CHR_OPERATING_UNIT_CODE
,      TCN_REPRESENTATION_TYPE
FROM APPS.OKL_CMN_EXTRACT_HDR_V;

Dependencies

[top of page]

APPS.OKL_CMN_EXTRACT_HDR_V references the following:

APPS: OKL_TRX_CONTRACTS_ALL; OKL_TRX_EXTENSION_B; XLA_EVENTS_GT

APPS.OKL_CMN_EXTRACT_HDR_V is referenced by following:

APPS: XLA_00540_AAD_S_000014_PKG - show dependent code