View: CSI_CP_FORM_CONFIG_V

Product:	CSI - Install Base
Description:	Backward Compatible : Customer Product Form Configuration.
Implementation/DBA Data:	APPS.CSI_CP_FORM_CONFIG_V

View Text

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(+)

Columns