FND Design Data [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: ViewAPPS.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