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


VIEW: APPS.CSD_SC_DOMAINS_V

Object Details
Object Name: CSD_SC_DOMAINS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSD.CSD_SC_DOMAINS_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row ID for the view.
SC_DOMAIN_ID NUMBER
Yes Primary key.
OBJECT_VERSION_NUMBER NUMBER
Yes Standard who column
SERVICE_CODE_ID NUMBER
Yes Foreign Key to CSD_DIAGNOSTIC_CODES
CREATED_BY NUMBER

Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE
Yes Standard who column - date when this row was created.
LAST_UPDATED_BY NUMBER (15) Yes Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_DATE DATE
Yes Standard Who column - date when a user last updated this row.
LAST_UPDATE_LOGIN NUMBER (15)
Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
DOMAIN_TYPE_CODE VARCHAR2 (30) Yes CSD_DOMAIN_TYPE_CODE lookup. Valid values are 'PROD' or 'CAT'
DOMAIN_TYPE_MEANING VARCHAR2 (80) Yes Domain type meaning. Valid values are 'PRODUCT' or 'CATEGORY'
INVENTORY_ITEM_ID NUMBER

Product ID if domain type code = 'PRODUCT' or else NULL.
INVENTORY_ITEM_NAME VARCHAR2 (40)
Product Name if domain type code = 'PRODUCT' or else NULL.
INVENTORY_ITEM_DESC VARCHAR2 (240)
Product Description if domain type code = 'PRODUCT' or else NULL.
CATEGORY_ID NUMBER

Category ID if domain type code = 'CATEGORY' or else NULL.
CATEGORY_NAME VARCHAR2 (163)
Category Name if domain type code = 'CATEGORY' or else NULL.
CATEGORY_DESC VARCHAR2 (240)
Category Description if domain type code = 'CATEGORY' or else NULL.
CATEGORY_SET_ID NUMBER

Category Set ID if domain type code = 'CATEGORY' or else NULL.
CATEGORY_SET_NAME VARCHAR2 (30)
Category Set Name if domain type code = 'CATEGORY' or else NULL.
CATEGORY_SET_DESC VARCHAR2 (240)
Category Set Description if domain type code = 'CATEGORY' or else NULL.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure definition column.
ATTRIBUTE1 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE2 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE3 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE4 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE5 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE6 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE7 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE8 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE9 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE10 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE11 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE12 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE13 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE14 VARCHAR2 (150)
Descriptive flexfield segment
ATTRIBUTE15 VARCHAR2 (150)
Descriptive flexfield segment
Query Text

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


SELECT ROW_ID
,      SC_DOMAIN_ID
,      OBJECT_VERSION_NUMBER
,      SERVICE_CODE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      DOMAIN_TYPE_CODE
,      DOMAIN_TYPE_MEANING
,      INVENTORY_ITEM_ID
,      INVENTORY_ITEM_NAME
,      INVENTORY_ITEM_DESC
,      CATEGORY_ID
,      CATEGORY_NAME
,      CATEGORY_DESC
,      CATEGORY_SET_ID
,      CATEGORY_SET_NAME
,      CATEGORY_SET_DESC
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.CSD_SC_DOMAINS_V;

Dependencies

[top of page]

APPS.CSD_SC_DOMAINS_V references the following:

SchemaAPPS
SynonymCSD_SC_DOMAINS
PL/SQL PackageCS_STD - show dependent code
PL/SQL PackageFND_GLOBAL - show dependent code
ViewFND_LOOKUPS
ViewMTL_CATEGORIES_V
ViewMTL_CATEGORY_SETS_V
SynonymMTL_SYSTEM_ITEMS_KFV
APPS.CSD_SC_DOMAINS_V is referenced by following:

SchemaAPPS
Package BodyCSD_RO_BULLETINS_PVT - show dependent code
Package BodyCSD_SC_DOMAINS_PVT - show dependent code