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_SHR_EXTRACT_HDR_V

Object Details

Object Name:	OKL_SHR_EXTRACT_HDR_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	OKL.OKL_SHR_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
TCN_ID	NUMBER		Yes	Primary key column
TEH_TERM_QUOTE_ACCEPT_DATE	DATE			Termination Quote Acceptance Date
TEH_TERM_QUOTE_NUM	NUMBER			Termination Quote Number
TEH_TERM_QUOTE_TYPE_CODE	VARCHAR2	(30)		Termination Quote Type Code
TCN_ACCRUAL_REVERSAL_DATE	DATE			Date on which the Accrual Transaction will be reversed
TCN_ACCRUAL_DATE	DATE			Date of accrual. I.e. date of recognition of income. Can be different than accrual transaction date.
TCN_ACCRUAL_STATUS_FLAG	VARCHAR2	(3)		Indicates the status of the accrual rule for the contract
TCN_OVERRIDE_STATUS_FLAG	VARCHAR2	(3)		Override status of the accrual transaction. user can prevent the recognition of income by overriding the accrual process by checking the override flag. Examples: Y, N
TCN_TAX_DEDUCTIBLE_LOCAL_FLAG	VARCHAR2	(3)		Local tax deductibility status. No processing is currently driven off this field
TCN_TAX_DEDUCTIBLE_CORP_FLAG	VARCHAR2	(3)		Corporate tax deductibility status. No processing is currently driven off this field
TCN_REBOOK_REASON_CODE	VARCHAR2	(30)		Rebook reason code. Points to FND lookup OKL_REBOOK_REASON
TCN_ACCRUAL_ACTIVITY_CODE	VARCHAR2	(30)		Denotes the activity of the accrual transaction I.e. whether the transaction is an accrual, non-accrual, reversal or catchup transaction

Query Text

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


SELECT TCN_ID
,      TEH_TERM_QUOTE_ACCEPT_DATE
,      TEH_TERM_QUOTE_NUM
,      TEH_TERM_QUOTE_TYPE_CODE
,      TCN_ACCRUAL_REVERSAL_DATE
,      TCN_ACCRUAL_DATE
,      TCN_ACCRUAL_STATUS_FLAG
,      TCN_OVERRIDE_STATUS_FLAG
,      TCN_TAX_DEDUCTIBLE_LOCAL_FLAG
,      TCN_TAX_DEDUCTIBLE_CORP_FLAG
,      TCN_REBOOK_REASON_CODE
,      TCN_ACCRUAL_ACTIVITY_CODE
FROM APPS.OKL_SHR_EXTRACT_HDR_V;

Dependencies

[top of page]

APPS.OKL_SHR_EXTRACT_HDR_V references the following:

APPS: OKL_TRX_CONTRACTS_ALL; OKL_TRX_EXTENSION_B

APPS.OKL_SHR_EXTRACT_HDR_V is referenced by following:

APPS: XLA_00540_AAD_S_000014_PKG - show dependent code