[Home] [Help]
View: CSI_T_II_RELATIONSHIPS_V
Product: | CSI - Install Base |
Description: | View on top of Transaction Details Relationships. CSI_T_II_RELATIONSHIPS_V |
Implementation/DBA Data: |
APPS.CSI_T_II_RELATIONSHIPS_V
|
View Text
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 CSI_T_II_RELATIONSHIPS
Columns
Name |
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 |