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.
[Home] [Help]
[Dependency Information]
VIEW: APPS.OKC_STATUSES_V
Object Details
Object Name: OKC_STATUSES_V
Object Type: VIEW
Owner: APPS
FND Design Data: OKC.OKC_STATUSES_V
Subobject Name:
Status: VALID
View Type A public view which may be useful for custom reporting or other data
requirements.
STATUS is a user or system assigned value the further defines a state or step in a life cycle.
Each STATUS must be of a STATUS TYPE, which represents a life cycle state.
STATUS is used to help drive ASSENT, which informs the system as to what OPERATIONS may be performed.
[View Source]
Columns
Name
Datatype
Length
Mandatory
Comments
ROW_ID
ROWID
(10)
Auto-generated by Headstart Utilities
CODE
VARCHAR2
(30)
Yes
Status code from FND_LOOKUP_VALUES.
OBJECT_VERSION_NUMBER
NUMBER
(9)
Yes
Sequential number set at 1 on insert and incremented on update. Used by APIs to ensure current record is passed.
SFWT_FLAG
VARCHAR2
(3)
Yes
Indicates a value was changed in another language. Not fully implemented in 11i
STE_CODE
VARCHAR2
(30)
Yes
Foreign key to FND_LOOKUP_VALUES.
MEANING
VARCHAR2
(90)
Yes
Short meaning associated with code value.
DESCRIPTION
VARCHAR2
(1995)
User entered free format text description.
DEFAULT_YN
VARCHAR2
(3)
Yes
Yes/No field.
START_DATE
DATE
Yes
The beginning of the active period, one second after midnight on the date indicated.
END_DATE
DATE
The end of the active period, one second before midnight on the date indicated.
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 ROW_ID
, CODE
, OBJECT_VERSION_NUMBER
, SFWT_FLAG
, STE_CODE
, MEANING
, DESCRIPTION
, DEFAULT_YN
, START_DATE
, END_DATE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
FROM APPS.OKC_STATUSES_V;
Dependencies
[top of page]
APPS.OKC_STATUSES_V references the following:
APPS
OKC_STATUSES_B
OKC_STATUSES_TL
APPS.OKC_STATUSES_V is referenced by following:
APPS
CSI_JAVA_INTERFACE_PKG
- show dependent code
CSI_UTL_PKG
- show dependent code
OKC_AST_PVT
- show dependent code
OKC_CHR_PVT
- show dependent code
OKC_CLE_PVT
- show dependent code
OKC_CONTRACT_APPROVAL_PVT
- show dependent code
OKC_CONTRACT_PUB
- show dependent code
OKC_EXTEND_PVT
- show dependent code
OKC_K_SALES_AGRMNTS_V
OKC_RENEW_PVT
- show dependent code
OKC_SALES_TEMPLATES_V
OKC_STATUS_CHANGE_PVT
- show dependent code
OKC_STS_PVT
- show dependent code
OKC_STS_PVT
- show dependent code
OKC_TERMINATE_PVT
- show dependent code
OKE_CHANGE_STATUS_PUB
- show dependent code
OKE_CHANGE_STATUS_PUB
- show dependent code
OKE_CONTRACT_APPROVAL_PVT
- show dependent code
OKE_DTS_SUBCONTRACTS_V
OKE_IMPORT_CONTRACT_PUB
- show dependent code
OKE_KCOPY_PKG
- show dependent code
OKE_K_DELIVERABLES_VL
OKE_K_DELIVERABLES_VLH
OKE_TERMINATE_LINES_V
OKL_AM_ASSET_LOV_UV
OKL_AM_ASSET_QUOTES_UV
OKL_AM_ASSET_RETURNS_UV
OKL_AM_ASSET_TRACK_UV
OKL_AM_CNTRCT_LN_TRMNT_PVT
- show dependent code
OKL_AM_CONTRACT_PARTIES_UV
OKL_AM_CREATE_QUOTE_PVT
- show dependent code
OKL_AM_LEASE_LOAN_TRMNT_PVT
- show dependent code
OKL_AM_LEASE_TRMNT_PVT
- show dependent code
OKL_AM_QUOTES_UV
OKL_AM_REPURCHASE_ASSET_HDR_UV
OKL_AM_TRMNT_TRANSACTIONS_UV
OKL_ASSET_LINES_ALL_V
OKL_BOOK_CONT_STAGE_UV
OKL_CONTRACT_BOOK_PVT
- show dependent code
OKL_CONTRACT_STATUS_PVT
- show dependent code
OKL_CRD_FUND_CHECKLISTS_TPL_UV
OKL_CRD_FUND_CHKLST_TPL_HDR_UV
OKL_CREDITLINES_UV
OKL_CREDIT_CHECKLISTS_UV
OKL_CS_ASSET_LINES_V
OKL_CS_CONT_PARTY_UV
OKL_CS_CONT_SRCH_RESULTS_UV
OKL_CS_CUST_INS_POLICY_UV
OKL_CS_LC_CONTRACT_PVT
- show dependent code
OKL_CS_LINE_VERSION_UV
OKL_FUNDING_CHECKLISTS_UV
OKL_FUNDING_PVT
- show dependent code
OKL_INVESTOR_BILLING_PVT
- show dependent code
OKL_KBK_APPROVALS_WF
- show dependent code
OKL_LA_PAYMENTS_PVT
- show dependent code
OKL_LA_SALES_TAX_PVT
- show dependent code
OKL_LEASEAPP_TEMPLATE_PVT
- show dependent code
OKL_LEASE_APP_PVT
- show dependent code
OKL_LOAN_BAL_UPDATE_PVT
- show dependent code
OKL_MAINTAIN_FEE_PVT
- show dependent code
OKL_NEW_ASSETS_UV
OKL_NEW_LOAN_ASSETS_UV
OKL_OKC_MIGRATION_PVT
- show dependent code
OKL_OLD_ASSETS_UV
OKL_OLD_LOAN_ASSETS_UV
OKL_PAYMENT_APPLICATION_PVT
- show dependent code
OKL_PAYMENT_SPLIT_PVT
- show dependent code
OKL_QA_DATA_INTEGRITY
- show dependent code
OKL_QUOTE_TO_CONTRACT_PVT
- show dependent code
OKL_RELEASE_PVT
- show dependent code
OKL_REVERSE_CONTRACT_PVT
- show dependent code
OKL_UBB_INTEGRATION_PVT
- show dependent code
OKL_VP_EXTEND_PVT
- show dependent code
OKL_VP_STS_PUB
- show dependent code
OKL_VP_STS_PVT
- show dependent code
OKL_VP_STS_PVT
- show dependent code
OKL_VP_TERMINATE_PVT
- show dependent code
OKS_AUTH_HEADERS_HV
OKS_AUTH_HEADERS_V
OKS_AUTH_UTIL_PUB
- show dependent code
OKS_CCMIGRATE_PVT
- show dependent code
OKS_CHANGE_STATUS_PVT
- show dependent code
OKS_COVERAGES_MIGRATION
- show dependent code
OKS_ENTITLEMENTS_PVT
- show dependent code
OKS_ENTITLEMENTS_PVT
- show dependent code
OKS_ENTITLEMENTS_WEB
- show dependent code
OKS_EXTWAR_UTIL_PUB
- show dependent code
OKS_EXTWAR_UTIL_PVT
- show dependent code
OKS_HEADER_DETAILS_V
OKS_IBINT_PUB
- show dependent code
OKS_IB_UTIL_PVT
- show dependent code
OKS_MASSCHANGE_PVT
- show dependent code
OKS_MASS_UPD_PVT
- show dependent code
OKS_OCINT_PUB
- show dependent code
OKS_RENEW_CONTRACT_PVT
- show dependent code
OKS_REPNAME_V
OKS_UPGRADE_PRECHECK
- show dependent code
OKS_VRM_HEADERS_V
OKS_VRM_LINES_V
OKS_WARRDATA_PUB
- show dependent code