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

VIEW: APPS.OKC_ARTICLES_V

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


[View Source]

Columns
Name Datatype Length Mandatory Comments
ARTICLE_ID NUMBER
Yes System generated Primary Key. This is used to identify Clause.
ARTICLE_TITLE VARCHAR2 (450) Yes The Title for the Clause. This is unique for a given operating unit.
ORG_ID NUMBER
Yes Owning Operating Unit of the Clause.
ARTICLE_NUMBER VARCHAR2 (240)
Clause Number - could be manually entered e.g. 55533.1 or generated using document sequence auto-numbering.
STANDARD_YN VARCHAR2 (1) Yes Yes/No flag to indicate whether the clause is standard or not.
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.
ARTICLE_LANGUAGE VARCHAR2 (4) Yes The language of the Clause. Foreign Key to FND_LANGUAGES (Base or Installed).
ARTICLE_TYPE VARCHAR2 (30)
This is the Clause Type. Based on the FND_LOOKUPS with lookup_type of OKC_ARTICLE_SUBJECT.
ORIG_SYSTEM_REFERENCE_CODE VARCHAR2 (30)
This column is used to preserve the code for the migrated system.
ORIG_SYSTEM_REFERENCE_ID1 VARCHAR2 (100)
This column is used to preserve the identifier1 for the migrated system.
ORIG_SYSTEM_REFERENCE_ID2 VARCHAR2 (100)
This column is used to preserve the identifier2 for the migrated system.
CZ_TRANSFER_STATUS_FLAG VARCHAR2 (1)
This column is used internally for refreshing the references in Contract Expert. The values are I-mported, N-ot Imported, R-efresh.
ARTICLE_VERSION_ID NUMBER
Yes System generated Primary Key. This is used to identify Clause Version.
ARTICLE_VERSION_NUMBER NUMBER
Yes This is the system generated version number of the clause. Sequence begins at 1.
ARTICLE_TEXT CLOB (4000)
This is the textual content of the clause including the embedded variables.
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.
INSERT_BY_REFERENCE VARCHAR2 (1) Yes Yes/No flag to determine the text that will be printed i.e. if Y then Clause should be printed without the clause text, if N then the clause text is printed.
LOCK_TEXT VARCHAR2 (1) Yes Yes/No flag to indicate whether the clause text can be modified on a business document (this flag determines whether user can modify a standard clause to create a non-standard clause).
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.
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.
SAV_RELEASE VARCHAR2 (50)
This is the user entered release label prior to 11.5.10. Kept for backward compatibility for migrated clauses.
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.
ADOPTION_TYPE VARCHAR2 (30)
This is the adoption type of the local clause. It could either be LOCALIZED (same as the adoption type of OKC_ARTICLE_ADOPTIONS) or LOCAL.
STD_ARTICLE_VERSION_ID NUMBER

This references the standard clause version for that was modified to create a non-standard clause. This is a foreign key to OKC_ARTICLE_VERSIONS.
DISPLAY_NAME VARCHAR2 (450)
This is the Clause Name that will be printed or displayed in a business document. If this column is not populated , the clause title will be used.
TRANSLATED_YN VARCHAR2 (1)
Yes/No flag to indicate whether the clause is created as a translation of global clause or not.
ARTICLE_DESCRIPTION VARCHAR2 (2000)
This is a short description of the Clause Version.
DATE_APPROVED DATE

This is the approval date of the clause.
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.
REFERENCE_SOURCE VARCHAR2 (150)
This is the reference source of the clause if the Insert By Reference column is Yes e.g. website/publication etc.
REFERENCE_TEXT VARCHAR2 (2000)
This is the reference text of the clause if the Insert By Reference column is Yes e.g. website/publication etc.
V_ORIG_SYSTEM_REFERENCE_CODE VARCHAR2 (30)
This column is used to preserve the code(Version) for the migrated system.
V_ORIG_SYSTEM_REFERENCE_ID1 VARCHAR2 (100)
This column is used to preserve the identifier1(Version) for the migrated system.
V_ORIG_SYSTEM_REFERENCE_ID2 VARCHAR2 (100)
This column is used to preserve the identifier2(Version) for the migrated system.
ADDITIONAL_INSTRUCTIONS VARCHAR2 (2000)
This column stores any additional instructions that are needed for using the Clause Version.
VARIATION_DESCRIPTION VARCHAR2 (240)
This is used in the case of non-standard articles to enter variations from Standard Articles prior to 11.5.10. This column is kept for backward compatibility.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield category column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield column.
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield column.
EDITED_IN_WORD VARCHAR2 (1)
ARTICLE_TEXT_IN_WORD BLOB (4000)
VARIABLE_CODE VARCHAR2 (150)
Query Text

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


SELECT ARTICLE_ID
,      ARTICLE_TITLE
,      ORG_ID
,      ARTICLE_NUMBER
,      STANDARD_YN
,      ARTICLE_INTENT
,      ARTICLE_LANGUAGE
,      ARTICLE_TYPE
,      ORIG_SYSTEM_REFERENCE_CODE
,      ORIG_SYSTEM_REFERENCE_ID1
,      ORIG_SYSTEM_REFERENCE_ID2
,      CZ_TRANSFER_STATUS_FLAG
,      ARTICLE_VERSION_ID
,      ARTICLE_VERSION_NUMBER
,      ARTICLE_TEXT
,      PROVISION_YN
,      INSERT_BY_REFERENCE
,      LOCK_TEXT
,      GLOBAL_YN
,      ARTICLE_STATUS
,      SAV_RELEASE
,      START_DATE
,      END_DATE
,      ADOPTION_TYPE
,      STD_ARTICLE_VERSION_ID
,      DISPLAY_NAME
,      TRANSLATED_YN
,      ARTICLE_DESCRIPTION
,      DATE_APPROVED
,      DEFAULT_SECTION
,      REFERENCE_SOURCE
,      REFERENCE_TEXT
,      V_ORIG_SYSTEM_REFERENCE_CODE
,      V_ORIG_SYSTEM_REFERENCE_ID1
,      V_ORIG_SYSTEM_REFERENCE_ID2
,      ADDITIONAL_INSTRUCTIONS
,      VARIATION_DESCRIPTION
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      EDITED_IN_WORD
,      ARTICLE_TEXT_IN_WORD
,      VARIABLE_CODE
FROM APPS.OKC_ARTICLES_V;

Dependencies

[top of page]

APPS.OKC_ARTICLES_V references the following:

SchemaAPPS
SynonymOKC_ARTICLES_ALL
SynonymOKC_ARTICLE_VERSIONS
APPS.OKC_ARTICLES_V is referenced by following:

SchemaAPPS
ViewOKC_K_ATE_V
ViewOKC_SECTIONED_ARTICLES_V
Package BodyOKC_TERMS_MIGRATE_GRP - show dependent code
Package BodyOKE_VERSION_COMPARISON_PKG - show dependent code