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

VIEW: APPS.CSI_T_II_RELATIONSHIPS_V

Object Details
Object Name: CSI_T_II_RELATIONSHIPS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSI.CSI_T_II_RELATIONSHIPS_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
TXN_RELATIONSHIP_ID NUMBER
Yes
TRANSACTION_LINE_ID NUMBER
Yes
SUBJECT_TYPE VARCHAR2 (1)
SUBJECT_ID NUMBER
Yes
SUB_CONFIG_INST_HDR_ID NUMBER

SUB_CONFIG_INST_REV_NUM NUMBER

SUB_CONFIG_INST_ITEM_ID NUMBER

RELATIONSHIP_TYPE_CODE VARCHAR2 (30)
OBJECT_TYPE VARCHAR2 (1)
OBJECT_ID NUMBER
Yes
OBJ_CONFIG_INST_HDR_ID NUMBER

OBJ_CONFIG_INST_REV_NUM NUMBER

OBJ_CONFIG_INST_ITEM_ID NUMBER

TARGET_COMMITMENT_DATE DATE

ACTIVE_START_DATE DATE

ACTIVE_END_DATE DATE

OBJECT_VERSION_NUMBER NUMBER
Yes
Query Text

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


SELECT TXN_RELATIONSHIP_ID
,      TRANSACTION_LINE_ID
,      SUBJECT_TYPE
,      SUBJECT_ID
,      SUB_CONFIG_INST_HDR_ID
,      SUB_CONFIG_INST_REV_NUM
,      SUB_CONFIG_INST_ITEM_ID
,      RELATIONSHIP_TYPE_CODE
,      OBJECT_TYPE
,      OBJECT_ID
,      OBJ_CONFIG_INST_HDR_ID
,      OBJ_CONFIG_INST_REV_NUM
,      OBJ_CONFIG_INST_ITEM_ID
,      TARGET_COMMITMENT_DATE
,      ACTIVE_START_DATE
,      ACTIVE_END_DATE
,      OBJECT_VERSION_NUMBER
FROM APPS.CSI_T_II_RELATIONSHIPS_V;

Dependencies

[top of page]

APPS.CSI_T_II_RELATIONSHIPS_V references the following:

SchemaAPPS
SynonymCSI_T_II_RELATIONSHIPS

APPS.CSI_T_II_RELATIONSHIPS_V is not referenced by any database object