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

VIEW: APPS.OKX_CONTRACTS_V

Object Details
Object Name: OKX_CONTRACTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_CONTRACTS_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
ID1 NUMBER
Yes Primary key column. unique identifier for the contract
ID2 CHAR (1)
Primary key column
NAME VARCHAR2 (241)
User assigned contract number
DESCRIPTION VARCHAR2 (600)
User assigned contract description
START_DATE_ACTIVE DATE

Contract effective from date
END_DATE_ACTIVE DATE

Contract effective to date
STATUS VARCHAR2 (1)
Indicates whether the contract record is active or inactive
PRIMARY_UOM_CODE VARCHAR2 (0)
Primary unit of measure code
SCS_CODE VARCHAR2 (30) Yes Contract subclass code
STS_CODE VARCHAR2 (30) Yes Contract status code
ORG_ID NUMBER
Yes Unique identifier for contract authoring operating unit
INV_ORG_ID NUMBER
Yes Unique identifier for contract inventory organization
BUY_OR_SELL VARCHAR2 (3)
CURRENCY_CODE VARCHAR2 (15)
Currency code
CHR_TYPE VARCHAR2 (30) Yes Contract type
Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      STATUS
,      PRIMARY_UOM_CODE
,      SCS_CODE
,      STS_CODE
,      ORG_ID
,      INV_ORG_ID
,      BUY_OR_SELL
,      CURRENCY_CODE
,      CHR_TYPE
FROM APPS.OKX_CONTRACTS_V;

Dependencies

[top of page]

APPS.OKX_CONTRACTS_V references the following:

SchemaAPPS
SynonymOKC_K_HEADERS_B
SynonymOKC_K_HEADERS_TL
APPS.OKX_CONTRACTS_V is referenced by following:

SchemaAPPS
Package BodyOKL_LA_VALIDATION_UTIL_PVT - show dependent code