eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ATTRIBUTE_UTIL SQL Statements

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

Line: 65


'SELECT  ' ||
'ATTR.ATTRIBUTE_ID "attributeID",  '||
'ATTR.ATTRIBUTE_TYPE "attributeType", '||
'ATTR.DISPLAY_STYLE "displayStyle", '||
--ENTY.ATTR_DATA_TYPE "attrDataType",
--ENTY.LOV_STRING "lovString",
'VAL.ATTR_VALUE "attrValue", '||
'VAL.ATTR_VALUE_EXTN "attrValueExtn", '||
--CODE.DESCRIPTION "CodeName",
--nvl(CODE.DESCRIPTION,VAL.ATTR_VALUE || ' (' || fnd_message.get_String('PV','PV_INVALID_VALUE')  || ')') "CodeName",
'case when VAL.ATTR_VALUE  is null   then ''''  '||
'	 when CODE.ATTR_CODE = VAL.ATTR_VALUE then  CODE.DESCRIPTION  '||
'	else VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')''  '||
'	end  ' ||
'	"CodeName", '||

'VAL.LAST_UPDATE_DATE "date" ' ||
'FROM ' ||
'PV_ATTRIBUTES_VL ATTR, ' ||
'PV_ENTY_ATTR_VALUES VAL,  ' ||
'PV_ENTITY_ATTRS ENTY, ' ||
'PV_ATTRIBUTE_CODES_VL CODE ' ||
'WHERE  ' ||
'ATTR.ATTRIBUTE_ID = :1 AND ' ||
'ATTR.ATTRIBUTE_ID = ENTY.ATTRIBUTE_ID AND ' ||
'ATTR.ATTRIBUTE_ID = VAL.ATTRIBUTE_ID AND ' ||
'ENTY.ENTITY = :2 AND ' ||
'VAL.ENTITY = ENTY.ENTITY AND ' ||
'VAL.ENTITY_ID = :3 AND ' ||
'VAL.VERSION = :4 AND ' ||
'CODE.ATTRIBUTE_ID(+)= VAL.ATTRIBUTE_ID AND ' ||
'CODE.ATTR_CODE (+)= VAL.ATTR_VALUE  ' ||
'ORDER BY  ' ||
'VAL.LAST_UPDATE_DATE '
;

Line: 110


l_last_update_date	DATE;

Line: 150


		FETCH lc_history_values INTO  l_attribute_id, l_attribute_type, l_display_style,   l_attr_value, l_attr_value_extn, l_code_name, l_last_update_date;

Line: 196


						select name into l_curr_value from fnd_currencies_vl
						where currency_code=l_curr_code;

Line: 273


	'SELECT '||
	'ATTR.ATTRIBUTE_ID "attributeID", '||
	'ATTR.ATTRIBUTE_TYPE "attributeType", '||
	'ATTR.DISPLAY_STYLE "displayStyle", '||
	'VAL.ATTR_VALUE "attrValue", '||
	'VAL.ATTR_VALUE_EXTN "attrValueExtn", '||
	--'CODE.DESCRIPTION "CodeName", '||
	--'nvl(CODE.DESCRIPTION,VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'')  || '')'') "CodeName", ' ||
	--'decode(CODE.DESCRIPTION,null,'',VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'')  || '')'') "CodeName", ' ||
	'case when VAL.ATTR_VALUE  is null   then '''' ' ||
		 'when CODE.ATTR_CODE = VAL.ATTR_VALUE then  CODE.DESCRIPTION ' ||
		 'else VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||
		 ' end ' ||

		 ' "CodeName", ' ||


	'VAL.LAST_UPDATE_DATE "date" '||
	'FROM '||
	'PV_ATTRIBUTES_VL ATTR, '||
	'PV_ENTY_ATTR_VALUES VAL, '||
	'PV_ENTITY_ATTRS ENTY, '||
	'PV_ATTRIBUTE_CODES_VL CODE '||
	'WHERE '||
	'ATTR.ATTRIBUTE_ID = :1 AND '||
	'ATTR.ATTRIBUTE_ID = ENTY.ATTRIBUTE_ID AND '||
	'ATTR.ATTRIBUTE_ID = VAL.ATTRIBUTE_ID AND '||
	'ENTY.ENTITY = :2 AND '||
	'VAL.ENTITY = ENTY.ENTITY AND '||
	'VAL.ENTITY_ID = :3 AND '||
	'ATTR.ATTRIBUTE_TYPE in (' || '''' || 'DROPDOWN' || '''' || ',' || '''' || 'TEXT' || '''' || ') AND '||
	'VAL.LATEST_FLAG(+) =' || '''' || 'Y'|| '''' || ' AND '||
	'CODE.ATTRIBUTE_ID(+)= VAL.ATTRIBUTE_ID AND '||
	'CODE.ATTR_CODE (+)= VAL.ATTR_VALUE  '||

	'UNION '||

	'SELECT '||
	'ATTR.ATTRIBUTE_ID "attributeID",  '||
	'ATTR.ATTRIBUTE_TYPE "attributeType", '||
	'ATTR.DISPLAY_STYLE "displayStyle",  '||
	'DECODE(ATTR.RETURN_TYPE, ' || '''' || 'NUMBER' || '''' || ', to_char(VAL.attr_value), VAL.attr_text) "attrValue", '||
	'''' || '' || '''' || ' "attrValueExtn", '||
	--'CODE.DESCRIPTION "CodeName", '||
	--'nvl(CODE.DESCRIPTION,VAL.ATTR_TEXT || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'')  || '')'') "CodeName", ' ||
	'case when VAL.ATTR_TEXT  is null   then '''' ' ||
		 'when CODE.ATTR_CODE = VAL.ATTR_TEXT then  CODE.DESCRIPTION ' ||
		 'else VAL.ATTR_TEXT || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||
		 ' end ' ||

		 ' "CodeName", ' ||

	'VAL.LAST_UPDATE_DATE "date" '||
	'FROM '||
	'PV_ATTRIBUTES_VL ATTR, '||
	'PV_SEARCH_ATTR_VALUES VAL, '||
	'PV_ENTITY_ATTRS ENTY, '||
	'PV_ATTRIBUTE_CODES_VL CODE '||
	'WHERE '||
	'ATTR.ATTRIBUTE_ID = :4 AND '||
	'ATTR.ATTRIBUTE_ID = ENTY.ATTRIBUTE_ID AND '||
	'ATTR.ATTRIBUTE_ID = VAL.ATTRIBUTE_ID AND '||
	'ENTY.ENTITY =  :5 AND '||
	'VAL.PARTY_ID = :6 AND '||
	'ENTY.DISPLAY_EXTERNAL_VALUE_FLAG = ' || '''' || 'Y' || '''' || ' AND '||
	'CODE.ATTRIBUTE_ID(+)= VAL.ATTRIBUTE_ID AND '||
	'CODE.ATTR_CODE (+)= VAL.ATTR_TEXT '
	;

Line: 342


'SELECT ' ||
'ATTR.ATTRIBUTE_ID "attributeID", ' ||
'ATTR.ATTRIBUTE_TYPE "attributeType", '||
'ATTR.DISPLAY_STYLE "displayStyle", ' ||
'VAL.ATTR_VALUE "attrValue", ' ||
'VAL.ATTR_VALUE_EXTN "attrValueExtn", '||
'CODE.DESCRIPTION "CodeName", '||
'VAL.LAST_UPDATE_DATE "date" ' ||
'FROM ' ||
'PV_ATTRIBUTES_VL ATTR, '||
'PV_ENTY_ATTR_VALUES VAL,  '||
'PV_ENTITY_ATTRS ENTY, ' ||
'PV_ATTRIBUTE_CODES_VL CODE '||
'WHERE ' ||
'ATTR.ATTRIBUTE_ID = :1 AND ' ||
'ATTR.ATTRIBUTE_ID = ENTY.ATTRIBUTE_ID AND ' ||
'ATTR.ATTRIBUTE_ID = VAL.ATTRIBUTE_ID AND ' ||
'ENTY.ENTITY = :2 AND ' ||
'VAL.ENTITY = ENTY.ENTITY AND ' ||
'VAL.ENTITY_ID = :3 AND ' ||
'VAL.LATEST_FLAG(+) =' || '''' || 'Y'|| '''' || ' AND ' ||
'CODE.ATTRIBUTE_ID(+)= VAL.ATTRIBUTE_ID AND ' ||
'CODE.ATTR_CODE (+)= VAL.ATTR_VALUE ' ||

'ORDER BY '||
'VAL.LAST_UPDATE_DATE ';

Line: 372


	'select attributeID, attributeType, displayStyle, attrValue, attrValueExtn, CodeName, updateDate from' ||
	' (select * from ' ||	'( SELECT ' ||
	'ATTR.ATTRIBUTE_ID attributeID,  ' ||
	'ATTR.ATTRIBUTE_TYPE attributeType, ' ||
	'ATTR.DISPLAY_STYLE displayStyle, ' ||
	'VAL.ATTR_VALUE attrValue, ' ||
	'VAL.ATTR_VALUE_EXTN attrValueExtn,  ' ||
	--'CODE.DESCRIPTION CodeName, ' ||
	--'nvl(CODE.DESCRIPTION,VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'')  || '')'') "CodeName", ' ||
	'case when VAL.ATTR_VALUE  is null   then '''' ' ||
		 'when CODE.ATTR_CODE = VAL.ATTR_VALUE then  CODE.DESCRIPTION ' ||
		 'else VAL.ATTR_VALUE || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||
		 ' end ' ||

		 ' CodeName, ' ||

	'VAL.LAST_UPDATE_DATE updateDate, ' ||
	'(MAX(VAL.VERSION) OVER (PARTITION BY VAL.ATTRIBUTE_ID)) MaxVersion, ' ||
	'VAL.VERSION version ' ||
	'FROM  ' ||
	'PV_ATTRIBUTES_VL ATTR,  ' ||
	'PV_ENTY_ATTR_VALUES VAL,  ' ||
	'PV_ENTITY_ATTRS ENTY, ' ||
	'PV_ATTRIBUTE_CODES_VL CODE ' ||
	'WHERE  ' ||
	'ATTR.ATTRIBUTE_ID = :1 AND ' ||
	'ATTR.ATTRIBUTE_ID = ENTY.ATTRIBUTE_ID AND ' ||
	'ATTR.ATTRIBUTE_ID = VAL.ATTRIBUTE_ID AND ' ||
	'ENTY.ENTITY = :2 AND ' ||
	'VAL.ENTITY = ENTY.ENTITY AND ' ||
	'VAL.ENTITY_ID = :3 AND ' ||
	--VAL.LATEST_FLAG(+) ='Y' AND
	--'VAL.LAST_UPDATE_DATE (+) <= to_date(pc_date,'dd-mon-yy hh:mi:ss') and ' ||
	--'VAL.LAST_UPDATE_DATE (+) <= to_date(:4,' || '''' || 'dd-mon-yy hh:mi:ss'|| '''' || ') and ' ||
	'VAL.LAST_UPDATE_DATE (+) <= to_date(:4,:5) and ' ||
	'CODE.ATTRIBUTE_ID(+)= VAL.ATTRIBUTE_ID AND ' ||
	'CODE.ATTR_CODE (+)= VAL.ATTR_VALUE  ' ||
	'ORDER BY VAL.LAST_UPDATE_DATE ' ||
	') ' ||
	'where NVL(version,0) = NVL(MaxVersion,0)  ' ||
	') ' ||

	'UNION '||

	'SELECT '||
	'ATTR.ATTRIBUTE_ID "attributeID",  '||
	'ATTR.ATTRIBUTE_TYPE "attributeType", '||
	'ATTR.DISPLAY_STYLE "displayStyle",  '||
	'DECODE(ATTR.RETURN_TYPE, ' || '''' || 'NUMBER' || '''' || ', to_char(VAL.attr_value), VAL.attr_text) "attrValue", '||
	'''' || '' || '''' || ' "attrValueExtn", '||
	--'CODE.DESCRIPTION "CodeName", '||
	--'nvl(CODE.DESCRIPTION,VAL.ATTR_TEXT || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'')  || '')'') "CodeName", ' ||
	'case when VAL.ATTR_TEXT  is null   then '''' ' ||
		 'when CODE.ATTR_CODE = VAL.ATTR_TEXT then  CODE.DESCRIPTION ' ||
		 'else VAL.ATTR_TEXT || '' ('' || fnd_message.get_String(''PV'',''PV_INVALID_VALUE'') || '')'' ' ||
		 ' end ' ||

		 ' "CodeName", ' ||

	'VAL.LAST_UPDATE_DATE "date" '||
	'FROM '||
	'PV_ATTRIBUTES_VL ATTR, '||
	'PV_SEARCH_ATTR_VALUES VAL, '||
	'PV_ENTITY_ATTRS ENTY, '||
	'PV_ATTRIBUTE_CODES_VL CODE '||
	'WHERE '||
	'ATTR.ATTRIBUTE_ID = :6 AND '||
	'ATTR.ATTRIBUTE_ID = ENTY.ATTRIBUTE_ID AND '||
	'ATTR.ATTRIBUTE_ID = VAL.ATTRIBUTE_ID AND '||
	'ENTY.ENTITY =  :7 AND '||
	'VAL.PARTY_ID = :8 AND '||
	'ENTY.DISPLAY_EXTERNAL_VALUE_FLAG = ' || '''' || 'Y' || '''' || ' AND '||
	'CODE.ATTRIBUTE_ID(+)= VAL.ATTRIBUTE_ID AND '||
	'CODE.ATTR_CODE (+)= VAL.ATTR_TEXT '
	;

Line: 459


l_last_update_date	DATE;

Line: 484


		SELECT attr.attribute_type,attr.decimal_points, enty.DISPLAY_EXTERNAL_VALUE_FLAG
		FROM  PV_ATTRIBUTES_VL attr, pv_entity_attrs enty
		WHERE attr.attribute_id =  cv_attribute_id and
		      attr.attribute_id= enty.attribute_id and
		      enty.entity=pc_entity
		      ;

Line: 512


	    --select attribute_type from pv_attributes_b into l_attribute_type where attribute_id = p_attribute_id;

Line: 551


		FETCH lc_attr_values INTO  l_attribute_id, l_attribute_type, l_display_style,   l_attr_value, l_attr_value_extn, l_code_name, l_last_update_date;

Line: 649


							select name into l_curr_value from fnd_currencies_vl
							where currency_code=l_curr_code;

Line: 658


							select name into l_curr_value from fnd_currencies_vl
							where currency_code=gl_user_currency_code;

Line: 727


							select name into l_curr_value from fnd_currencies_vl
							where currency_code=l_curr_code;

Line: 749


							select name into l_curr_value from fnd_currencies_vl
							where currency_code=gl_user_currency_code;

Line: 856


     l_lov_string := 'select * from ( ' || replace(lov_string,'?',':1') || ' ) where code = :2 ';