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

VIEW: APPS.OKC_ARTICLES_GLOBAL_V

Object Details
Object Name: OKC_ARTICLES_GLOBAL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKC.OKC_ARTICLES_GLOBAL_V
Subobject Name:
Status: VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.


DEFINITION
This view stores the standard clauses information owned by the global operating unit.


[View Source]

Columns
Name Datatype Length Mandatory Comments
ARTICLE_TITLE VARCHAR2 (450) Yes The Title for the Clause. This is unique for a given operating unit.
ARTICLE_NUMBER VARCHAR2 (240)
Clause Number - could be manually entered e.g. 55533.1 or generated using document sequence auto-numbering.
ARTICLE_TYPE VARCHAR2 (30)
This is the Clause Type. Based on the FND_LOOKUPS with lookup_type of OKC_SUBJECT.
TYPE_MEANING VARCHAR2 (80)
The Subject Meaning or Type Meaning - takes value from MEANING column of FND_LOOKUPS view
ARTICLE_VERSION_NUMBER NUMBER
Yes This is the system generated version number of the clause. Sequence begins at 1.
ARTICLE_STATUS VARCHAR2 (30)
This is the status of Standard Clause. This is a foreign key to FND_LOOKUP_VALUES with LOOKUP_TYPE = OKC_ARTICLE_STATUS.
STATUS_MEANING VARCHAR2 (80) Yes The Status Meaning - takes value from MEANING column of FND_LOOKUPS view
GLOBAL_YN VARCHAR2 (1) Yes Yes/No flag to indicate whether the clause is global or not i.e. if Y then Global , if N then Local.
GLOBAL_MEANING VARCHAR2 (80) Yes The Global Y/N flag Meaning - takes value from MEANING column of FND_LOOKUPS view
ARTICLE_TEXT CLOB (4000)
This is the textual content of the clause including the embedded variables.
ARTICLE_DESCRIPTION VARCHAR2 (2000)
This is a short description of the Clause Version.
ORG_ID NUMBER
Yes Owning operating unit of the Clause. In this context, this would be the global organization as identified in the profile option 'OKC: Global Operating Unit'.
ARTICLE_ID NUMBER
Yes System generated Primary Key. This is used to identify Clause.
ARTICLE_VERSION_ID NUMBER
Yes System generated Primary Key. This is used to identify Clause Version.
ARTICLE_INTENT VARCHAR2 (1) Yes This is the Clause Intent i.e. Buy or Sell. Foreign Key to FND_LOOKUPS of lookup_type OKC_ARTICLE_INTENT.
INTENT_MEANING VARCHAR2 (80) Yes Refers to the intent of the Clause - Buy or Sell - takes value from MEANING column of FND_LOOKUPS view
PROVISION_YN VARCHAR2 (1) Yes Yes/No field to indicate whether the clause is provision or not i.e. if Y then Provision, if N then Clause.
PROVISION_MEANING VARCHAR2 (80) Yes The Provision Y/N flag Meaning - takes value from MEANING column of FND_LOOKUPS view
START_DATE DATE

This is the Effective Start Date of the Standard Clause Version
END_DATE DATE

This is the Effective End Date of the Standard Clause Version.
DEFAULT_SECTION VARCHAR2 (30)
This is the default section to which the clause belongs. Foreign Key to FND_LOOKUPS where Lookup_Type = OKC_ARTICLE_SECTION.
DSECTION_MEANING VARCHAR2 (80)
The Default Section Meaning - takes value from MEANING column of FND_LOOKUPS view
Query Text

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


SELECT ARTICLE_TITLE
,      ARTICLE_NUMBER
,      ARTICLE_TYPE
,      TYPE_MEANING
,      ARTICLE_VERSION_NUMBER
,      ARTICLE_STATUS
,      STATUS_MEANING
,      GLOBAL_YN
,      GLOBAL_MEANING
,      ARTICLE_TEXT
,      ARTICLE_DESCRIPTION
,      ORG_ID
,      ARTICLE_ID
,      ARTICLE_VERSION_ID
,      ARTICLE_INTENT
,      INTENT_MEANING
,      PROVISION_YN
,      PROVISION_MEANING
,      START_DATE
,      END_DATE
,      DEFAULT_SECTION
,      DSECTION_MEANING
FROM APPS.OKC_ARTICLES_GLOBAL_V;

Dependencies

[top of page]

APPS.OKC_ARTICLES_GLOBAL_V references the following:

SchemaAPPS
SynonymOKC_ARTICLES_ALL
SynonymOKC_ARTICLE_VERSIONS
ViewOKC_LOOKUPS_V
APPS.OKC_ARTICLES_GLOBAL_V is referenced by following:

SchemaAPPS
Package BodyOKC_PO_MOD_PKG - show dependent code
Package BodyOKC_TERMS_MIGRATE_GRP - show dependent code