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

VIEW: APPS.OKC_STD_ART_CLASSINGS_V

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

View Type

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


DEFINTION
A STANDARD ARTICLE CLASSIFICATION is a user defined combination of STANDARD ARTICLE and one of PRICE TYPE or VARIETY. Once created these combination may not be modified. They can be expired, making them available for use, by setting the END DATE appropriately.
EXAMPLE
MISCELLANEOUS


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
The address of the row in the database
ID NUMBER
Yes Primary key column.
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.
SAT_CODE VARCHAR2 (30) Yes Surrogate key used for primary unique identifiers.
PRICE_TYPE VARCHAR2 (30)
Price type.
SCS_CODE VARCHAR2 (30)
Foreign key to FND_LOOKUP_VALUES.
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
,      ID
,      OBJECT_VERSION_NUMBER
,      SAT_CODE
,      PRICE_TYPE
,      SCS_CODE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.OKC_STD_ART_CLASSINGS_V;

Dependencies

[top of page]

APPS.OKC_STD_ART_CLASSINGS_V references the following:

SchemaAPPS
SynonymOKC_STD_ART_CLASSINGS
APPS.OKC_STD_ART_CLASSINGS_V is referenced by following:

SchemaAPPS
Package BodyOKC_SAC_PVT - show dependent code
PL/SQL PackageOKC_SAC_PVT - show dependent code