VIEW: APPS.CS_CP_PARAMETERS_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'