DBA Data[Home] [Help] [Dependency Information]


VIEW: APPS.OKC_STATUSES_V

Object Details
Object Name: OKC_STATUSES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.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:

SchemaAPPS
SynonymOKC_STATUSES_B
SynonymOKC_STATUSES_TL
APPS.OKC_STATUSES_V is referenced by following:

SchemaAPPS
Package BodyCSI_JAVA_INTERFACE_PKG - show dependent code
Package BodyCSI_UTL_PKG - show dependent code
Package BodyOKC_AST_PVT - show dependent code
PL/SQL PackageOKC_CHR_PVT - show dependent code
PL/SQL PackageOKC_CLE_PVT - show dependent code
Package BodyOKC_CONTRACT_APPROVAL_PVT - show dependent code
Package BodyOKC_CONTRACT_PUB - show dependent code
Package BodyOKC_EXTEND_PVT - show dependent code
ViewOKC_K_SALES_AGRMNTS_V
Package BodyOKC_RENEW_PVT - show dependent code
ViewOKC_SALES_TEMPLATES_V
Package BodyOKC_STATUS_CHANGE_PVT - show dependent code
PL/SQL PackageOKC_STS_PVT - show dependent code
Package BodyOKC_STS_PVT - show dependent code
Package BodyOKC_TERMINATE_PVT - show dependent code
Package BodyOKE_CHANGE_STATUS_PUB - show dependent code
PL/SQL PackageOKE_CHANGE_STATUS_PUB - show dependent code
Package BodyOKE_CONTRACT_APPROVAL_PVT - show dependent code
ViewOKE_DTS_SUBCONTRACTS_V
Package BodyOKE_IMPORT_CONTRACT_PUB - show dependent code
Package BodyOKE_KCOPY_PKG - show dependent code
ViewOKE_K_DELIVERABLES_VL
ViewOKE_K_DELIVERABLES_VLH
ViewOKE_TERMINATE_LINES_V
ViewOKL_AM_ASSET_LOV_UV
ViewOKL_AM_ASSET_QUOTES_UV
ViewOKL_AM_ASSET_RETURNS_UV
ViewOKL_AM_ASSET_TRACK_UV
Package BodyOKL_AM_CNTRCT_LN_TRMNT_PVT - show dependent code
ViewOKL_AM_CONTRACT_PARTIES_UV
Package BodyOKL_AM_CREATE_QUOTE_PVT - show dependent code
Package BodyOKL_AM_LEASE_LOAN_TRMNT_PVT - show dependent code
Package BodyOKL_AM_LEASE_TRMNT_PVT - show dependent code
ViewOKL_AM_QUOTES_UV
ViewOKL_AM_REPURCHASE_ASSET_HDR_UV
ViewOKL_AM_TRMNT_TRANSACTIONS_UV
ViewOKL_ASSET_LINES_ALL_V
ViewOKL_BOOK_CONT_STAGE_UV
Package BodyOKL_CONTRACT_BOOK_PVT - show dependent code
Package BodyOKL_CONTRACT_STATUS_PVT - show dependent code
ViewOKL_CRD_FUND_CHECKLISTS_TPL_UV
ViewOKL_CRD_FUND_CHKLST_TPL_HDR_UV
ViewOKL_CREDITLINES_UV
ViewOKL_CREDIT_CHECKLISTS_UV
ViewOKL_CS_ASSET_LINES_V
ViewOKL_CS_CONT_PARTY_UV
ViewOKL_CS_CONT_SRCH_RESULTS_UV
ViewOKL_CS_CUST_INS_POLICY_UV
Package BodyOKL_CS_LC_CONTRACT_PVT - show dependent code
ViewOKL_CS_LINE_VERSION_UV
ViewOKL_FUNDING_CHECKLISTS_UV
Package BodyOKL_FUNDING_PVT - show dependent code
Package BodyOKL_INVESTOR_BILLING_PVT - show dependent code
Package BodyOKL_KBK_APPROVALS_WF - show dependent code
Package BodyOKL_LA_PAYMENTS_PVT - show dependent code
Package BodyOKL_LA_SALES_TAX_PVT - show dependent code
Package BodyOKL_LEASEAPP_TEMPLATE_PVT - show dependent code
Package BodyOKL_LEASE_APP_PVT - show dependent code
Package BodyOKL_LOAN_BAL_UPDATE_PVT - show dependent code
Package BodyOKL_MAINTAIN_FEE_PVT - show dependent code
ViewOKL_NEW_ASSETS_UV
ViewOKL_NEW_LOAN_ASSETS_UV
PL/SQL PackageOKL_OKC_MIGRATION_PVT - show dependent code
ViewOKL_OLD_ASSETS_UV
ViewOKL_OLD_LOAN_ASSETS_UV
Package BodyOKL_PAYMENT_APPLICATION_PVT - show dependent code
Package BodyOKL_PAYMENT_SPLIT_PVT - show dependent code
Package BodyOKL_QA_DATA_INTEGRITY - show dependent code
Package BodyOKL_QUOTE_TO_CONTRACT_PVT - show dependent code
Package BodyOKL_RELEASE_PVT - show dependent code
Package BodyOKL_REVERSE_CONTRACT_PVT - show dependent code
Package BodyOKL_UBB_INTEGRATION_PVT - show dependent code
Package BodyOKL_VP_EXTEND_PVT - show dependent code
PL/SQL PackageOKL_VP_STS_PUB - show dependent code
Package BodyOKL_VP_STS_PVT - show dependent code
PL/SQL PackageOKL_VP_STS_PVT - show dependent code
Package BodyOKL_VP_TERMINATE_PVT - show dependent code
ViewOKS_AUTH_HEADERS_HV
ViewOKS_AUTH_HEADERS_V
Package BodyOKS_AUTH_UTIL_PUB - show dependent code
Package BodyOKS_CCMIGRATE_PVT - show dependent code
Package BodyOKS_CHANGE_STATUS_PVT - show dependent code
Package BodyOKS_COVERAGES_MIGRATION - show dependent code
PL/SQL PackageOKS_ENTITLEMENTS_PVT - show dependent code
Package BodyOKS_ENTITLEMENTS_PVT - show dependent code
Package BodyOKS_ENTITLEMENTS_WEB - show dependent code
Package BodyOKS_EXTWAR_UTIL_PUB - show dependent code
Package BodyOKS_EXTWAR_UTIL_PVT - show dependent code
ViewOKS_HEADER_DETAILS_V
Package BodyOKS_IBINT_PUB - show dependent code
Package BodyOKS_IB_UTIL_PVT - show dependent code
Package BodyOKS_MASSCHANGE_PVT - show dependent code
Package BodyOKS_MASS_UPD_PVT - show dependent code
Package BodyOKS_OCINT_PUB - show dependent code
Package BodyOKS_RENEW_CONTRACT_PVT - show dependent code
ViewOKS_REPNAME_V
Package BodyOKS_UPGRADE_PRECHECK - show dependent code
ViewOKS_VRM_HEADERS_V
ViewOKS_VRM_LINES_V
Package BodyOKS_WARRDATA_PUB - show dependent code