Product: | CS - Service |
---|---|
Description: | This view lists the Parameter details of each product in InstalledBase. |
Implementation/DBA Data: | APPS.CS_CP_PARAMETERS_V |
SELECT PARM.CP_PARAMETER_ID
, PARM.CUSTOMER_PRODUCT_ID
, PARM.PARAMETER_TYPE
, PARM.NAME
, PARM.VALUE
, PARM.STATUS
, PARM.APPLICATION_ID
, PARM.START_DATE_ACTIVE
, PARM.END_DATE_ACTIVE
, PARM.LAST_UPDATED_BY
, PARM.LAST_UPDATE_DATE
, PARM.CREATED_BY
, PARM.CREATION_DATE
, PARM.LAST_UPDATE_LOGIN
, PARM.ATTRIBUTE1
, PARM.ATTRIBUTE2
, PARM.ATTRIBUTE3
, PARM.ATTRIBUTE4
, PARM.ATTRIBUTE5
, PARM.ATTRIBUTE6
, PARM.ATTRIBUTE7
, PARM.ATTRIBUTE8
, PARM.ATTRIBUTE9
, PARM.ATTRIBUTE10
, PARM.ATTRIBUTE11
, PARM.ATTRIBUTE12
, PARM.ATTRIBUTE13
, PARM.ATTRIBUTE14
, PARM.ATTRIBUTE15
, PARM.CONTEXT
, LK1.MEANING PARAMETER_TYPE_MEANING
, LK2.MEANING STATUS_MEANING
FROM ASO_LOOKUPS LK1
, ASO_LOOKUPS LK2
, CS_CP_PARAMETERS PARM
WHERE PARM.PARAMETER_TYPE = LK1.LOOKUP_CODE(+)
AND PARM.STATUS = LK2.LOOKUP_CODE(+)
AND LK1.LOOKUP_TYPE(+) = 'ASO_LINE_ATTRIBUTE_TYPE'
AND LK2.LOOKUP_TYPE(+) = 'ASO_LINE_ATTRIBUTE_STATUS'