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

VIEW: APPS.CSP_SUPERSESIONS_V

Object Details
Object Name: CSP_SUPERSESIONS_V
Object Type: VIEW
Owner: APPS
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 identifier
REPAIRTO_ROW_ID ROWID (10)
Repair to row identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
INVENTORY_ITEM_ID NUMBER
Yes Item identifier
RELATED_ITEM_ID NUMBER
Yes Related item identifier
RELATIONSHIP_TYPE_ID NUMBER
Yes Relationship type identifier
RECIPROCAL_FLAG VARCHAR2 (1) Yes Reciprocal flag
START_DATE DATE

Start date
END_DATE DATE

End date
ATTR_CONTEXT VARCHAR2 (30)
Attribue context
ATTR_CHAR1 VARCHAR2 (150)
Character attribute
ATTR_CHAR2 VARCHAR2 (150)
Character attribute
ATTR_CHAR3 VARCHAR2 (150)
Character attribute
ATTR_CHAR4 VARCHAR2 (150)
Character attribute
ATTR_CHAR5 VARCHAR2 (150)
Character attribute
ATTR_CHAR6 VARCHAR2 (150)
Character attribute
ATTR_CHAR7 VARCHAR2 (150)
Character attribute
ATTR_CHAR8 VARCHAR2 (150)
Character attribute
ATTR_CHAR9 VARCHAR2 (150)
Character attribute
ATTR_CHAR10 VARCHAR2 (150)
Character attribute
ATTR_NUM1 VARCHAR2 (150)
Number attribute
ATTR_NUM2 VARCHAR2 (150)
Number attribute
ATTR_NUM3 VARCHAR2 (150)
Number attribute
ATTR_NUM4 VARCHAR2 (150)
Number attribute
ATTR_NUM5 VARCHAR2 (150)
Number attribute
ATTR_NUM6 VARCHAR2 (150)
Number attribute
ATTR_NUM7 VARCHAR2 (150)
Number attribute
ATTR_NUM8 VARCHAR2 (150)
Number attribute
ATTR_NUM9 VARCHAR2 (150)
Number attribute
ATTR_NUM10 VARCHAR2 (150)
Number attribute
ATTR_DATE1 VARCHAR2 (150)
Date attribute
ATTR_DATE2 VARCHAR2 (150)
Date attribute
ATTR_DATE3 VARCHAR2 (150)
Date attribute
ATTR_DATE4 VARCHAR2 (150)
Date attribute
ATTR_DATE5 VARCHAR2 (150)
Date attribute
ATTR_DATE6 VARCHAR2 (150)
Date attribute
ATTR_DATE7 VARCHAR2 (150)
Date attribute
ATTR_DATE8 VARCHAR2 (150)
Date attribute
ATTR_DATE9 VARCHAR2 (150)
Date attribute
ATTR_DATE10 VARCHAR2 (150)
Date attribute
LAST_UPDATE_DATE DATE
Yes Standard Who Column
LAST_UPDATED_BY NUMBER
Yes Standard Who column - with the user id from FND_USER
CREATION_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER
Yes Standard Who column - with the user id from FND_USER
LAST_UPDATE_LOGIN NUMBER

Standard Who column - with the user id from FND_USER
REQUEST_ID NUMBER

Standard Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
DISPOSITION VARCHAR2 (1) Yes Disposition
INVENTORY_ITEM_DESCRIPTION VARCHAR2 (240)
Item description
RELATED_ITEM_DESCRIPTION VARCHAR2 (240)
Related item description
REPAIRTO_ITEM_ID NUMBER

Repair to item identifier
REPAIRTO_ITEM_DESCRIPTION VARCHAR2 (240)
Repair to item description
REPLACED_ITEM_NUMBER VARCHAR2 (40)
Replaced item number
RELATED_ITEM_NUMBER VARCHAR2 (40)
Related item number
REPAIRTO_ITEM_NUMBER VARCHAR2 (40)
Repair to item number
Query Text

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


SELECT ROW_ID
,      REPAIRTO_ROW_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      RELATED_ITEM_ID
,      RELATIONSHIP_TYPE_ID
,      RECIPROCAL_FLAG
,      START_DATE
,      END_DATE
,      ATTR_CONTEXT
,      ATTR_CHAR1
,      ATTR_CHAR2
,      ATTR_CHAR3
,      ATTR_CHAR4
,      ATTR_CHAR5
,      ATTR_CHAR6
,      ATTR_CHAR7
,      ATTR_CHAR8
,      ATTR_CHAR9
,      ATTR_CHAR10
,      ATTR_NUM1
,      ATTR_NUM2
,      ATTR_NUM3
,      ATTR_NUM4
,      ATTR_NUM5
,      ATTR_NUM6
,      ATTR_NUM7
,      ATTR_NUM8
,      ATTR_NUM9
,      ATTR_NUM10
,      ATTR_DATE1
,      ATTR_DATE2
,      ATTR_DATE3
,      ATTR_DATE4
,      ATTR_DATE5
,      ATTR_DATE6
,      ATTR_DATE7
,      ATTR_DATE8
,      ATTR_DATE9
,      ATTR_DATE10
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      DISPOSITION
,      INVENTORY_ITEM_DESCRIPTION
,      RELATED_ITEM_DESCRIPTION
,      REPAIRTO_ITEM_ID
,      REPAIRTO_ITEM_DESCRIPTION
,      REPLACED_ITEM_NUMBER
,      RELATED_ITEM_NUMBER
,      REPAIRTO_ITEM_NUMBER
FROM APPS.CSP_SUPERSESIONS_V;

Dependencies

[top of page]

APPS.CSP_SUPERSESIONS_V references the following:

SchemaAPPS
SynonymMTL_RELATED_ITEMS
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymMTL_SYSTEM_ITEMS_TL

APPS.CSP_SUPERSESIONS_V is not referenced by any database object