DBA Data[Home] [Help]

APPS.PV_CMDASHBOARD_UTIL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

	SELECT pav.name name, pav.return_type return_type, pav.display_style display_style,
	       pea.sql_text sql_text, pav.enabled_flag enabled_flag
	FROM pv_entity_attrs pea,
	     pv_attributes_vl pav
	WHERE entity = 'PARTNER_GROUP_KPI'
	AND pea.attribute_id = pav.attribute_id
	AND pav.attribute_id = cv_attribute_id
	AND pav.enabled_flag = 'Y';