VIEW: APPS.CSI_CP_FORM_CONFIG_V

Source

View Text - Preformatted

SELECT CII.INSTANCE_ID CUSTOMER_PRODUCT_ID, CIR.RELATIONSHIP_ID RELATIONSHIP_ID, CIR.OBJECT_VERSION_NUMBER EXT_OBJECT_VERSION_NUMBER, NVL( CIR.RELATIONSHIP_TYPE_CODE, CIVL.VERSION_LABEL) CP_CONFIG_TYPE, NVL( CIR.ACTIVE_START_DATE, CIVL.DATE_TIME_STAMP) CONFIG_START_DATE, CIR.ACTIVE_END_DATE CONFIG_END_DATE, CIRT.NAME CONFIG_TYPE, 'Y' CONFIG_ENABLED_FLAG, CIR.OBJECT_ID PARENT_CP_ID, CSICUMPI_PUB.GET_PART_INFORMATION( CIR.OBJECT_ID ) CONFIG_PARENT_INFO, NVL( CSICUMPI_PUB.GET_ROOT_INFORMATION( CII.INSTANCE_ID ), CSICUMPI_PUB.GET_PART_INFORMATION( CII.INSTANCE_ID ) ) CONFIG_ROOT_INFO, CSICUMPI_PUB.GET_CHILDREN_FLAG( CII.INSTANCE_ID ) CONFIG_CHILDREN_FLAG FROM CSI_II_RELATION_TYPES CIRT, CSI_II_RELATIONSHIPS CIR, CSI_ITEM_INSTANCES CII, CSI_I_VERSION_LABELS CIVL WHERE CII.INSTANCE_ID = CIR.SUBJECT_ID(+) AND CIVL.INSTANCE_ID(+) = CII.INSTANCE_ID AND CIR.RELATIONSHIP_TYPE_CODE (+) = 'COMPONENT_OF' AND CIR.ACTIVE_END_DATE (+) IS NULL AND CIR.RELATIONSHIP_TYPE_CODE = CIRT.RELATIONSHIP_TYPE_CODE(+)

View Text - HTML Formatted

SELECT CII.INSTANCE_ID CUSTOMER_PRODUCT_ID
, CIR.RELATIONSHIP_ID RELATIONSHIP_ID
, CIR.OBJECT_VERSION_NUMBER EXT_OBJECT_VERSION_NUMBER
, NVL( CIR.RELATIONSHIP_TYPE_CODE
, CIVL.VERSION_LABEL) CP_CONFIG_TYPE
, NVL( CIR.ACTIVE_START_DATE
, CIVL.DATE_TIME_STAMP) CONFIG_START_DATE
, CIR.ACTIVE_END_DATE CONFIG_END_DATE
, CIRT.NAME CONFIG_TYPE
, 'Y' CONFIG_ENABLED_FLAG
, CIR.OBJECT_ID PARENT_CP_ID
, CSICUMPI_PUB.GET_PART_INFORMATION( CIR.OBJECT_ID ) CONFIG_PARENT_INFO
, NVL( CSICUMPI_PUB.GET_ROOT_INFORMATION( CII.INSTANCE_ID )
, CSICUMPI_PUB.GET_PART_INFORMATION( CII.INSTANCE_ID ) ) CONFIG_ROOT_INFO
, CSICUMPI_PUB.GET_CHILDREN_FLAG( CII.INSTANCE_ID ) CONFIG_CHILDREN_FLAG
FROM CSI_II_RELATION_TYPES CIRT
, CSI_II_RELATIONSHIPS CIR
, CSI_ITEM_INSTANCES CII
, CSI_I_VERSION_LABELS CIVL
WHERE CII.INSTANCE_ID = CIR.SUBJECT_ID(+)
AND CIVL.INSTANCE_ID(+) = CII.INSTANCE_ID
AND CIR.RELATIONSHIP_TYPE_CODE (+) = 'COMPONENT_OF'
AND CIR.ACTIVE_END_DATE (+) IS NULL
AND CIR.RELATIONSHIP_TYPE_CODE = CIRT.RELATIONSHIP_TYPE_CODE(+)