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

VIEW: APPS.CS_SR_PROB_CODE_MAPPING_V

Object Details
Object Name: CS_SR_PROB_CODE_MAPPING_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_SR_PROB_CODE_MAPPING_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
ROW_ID ROWID (10)
Row Id
PROBLEM_MAP_ID NUMBER (5) Yes The unique identifier of the mapping.
PROBLEM_MAP_DETAIL_ID NUMBER (5) Yes Problem Map Detail Id
PROBLEM_CODE VARCHAR2 (30) Yes The problem code of the SR.
INCIDENT_TYPE_ID NUMBER (15)
The service request type identifier.
INVENTORY_ITEM_ID NUMBER

The inventory item identifier.
ORGANIZATION_ID NUMBER

The organization identifier.
CATEGORY_ID NUMBER

Product Category Identifier
START_DATE_ACTIVE DATE

The start date from when the mapping will be valid.
END_DATE_ACTIVE DATE

The end date until when the mapping is valid.
MAP_START_DATE_ACTIVE DATE

Active Start Date of the mapping
MAP_END_DATE_ACTIVE DATE

Active End Date of the mapping
OBJECT_VERSION_NUMBER NUMBER (9)
Object Version number.
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.
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield segment.
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.
PROBLEM_MEANING VARCHAR2 (80) Yes Meaning of the problem code.
INCIDENT_TYPE VARCHAR2 (90)
The service request type .
INVENTORY_ITEM VARCHAR2 (40)
The inventory item.
DESCRIPTION VARCHAR2 (240)
The description of problem code.
CATEGORY_NAME VARCHAR2 (163)
Category Name
Query Text

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


SELECT ROW_ID
,      PROBLEM_MAP_ID
,      PROBLEM_MAP_DETAIL_ID
,      PROBLEM_CODE
,      INCIDENT_TYPE_ID
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      CATEGORY_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      MAP_START_DATE_ACTIVE
,      MAP_END_DATE_ACTIVE
,      OBJECT_VERSION_NUMBER
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      PROBLEM_MEANING
,      INCIDENT_TYPE
,      INVENTORY_ITEM
,      DESCRIPTION
,      CATEGORY_NAME
FROM APPS.CS_SR_PROB_CODE_MAPPING_V;

Dependencies

[top of page]

APPS.CS_SR_PROB_CODE_MAPPING_V references the following:

SchemaAPPS
ViewCS_INCIDENT_TYPES_VL
ViewCS_LOOKUPS
SynonymCS_SR_PROB_CODE_MAPPING_DETAIL
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymMTL_CATEGORIES_KFV
SynonymMTL_SYSTEM_ITEMS_KFV

APPS.CS_SR_PROB_CODE_MAPPING_V is not referenced by any database object