[Home] [Help] [Dependency Information]
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 |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
|
|
|