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 dependencies on PV_ATTRIBUTES_VL

Line 83: 'PV_ATTRIBUTES_VL ATTR, ' ||

79: ' "CodeName", '||
80:
81: 'VAL.LAST_UPDATE_DATE "date" ' ||
82: 'FROM ' ||
83: 'PV_ATTRIBUTES_VL ATTR, ' ||
84: 'PV_ENTY_ATTR_VALUES VAL, ' ||
85: 'PV_ENTITY_ATTRS ENTY, ' ||
86: 'PV_ATTRIBUTE_CODES_VL CODE ' ||
87: 'WHERE ' ||

Line 292: 'PV_ATTRIBUTES_VL ATTR, '||

288:
289:
290: 'VAL.LAST_UPDATE_DATE "date" '||
291: 'FROM '||
292: 'PV_ATTRIBUTES_VL ATTR, '||
293: 'PV_ENTY_ATTR_VALUES VAL, '||
294: 'PV_ENTITY_ATTRS ENTY, '||
295: 'PV_ATTRIBUTE_CODES_VL CODE '||
296: 'WHERE '||

Line 327: 'PV_ATTRIBUTES_VL ATTR, '||

323: ' "CodeName", ' ||
324:
325: 'VAL.LAST_UPDATE_DATE "date" '||
326: 'FROM '||
327: 'PV_ATTRIBUTES_VL ATTR, '||
328: 'PV_SEARCH_ATTR_VALUES VAL, '||
329: 'PV_ENTITY_ATTRS ENTY, '||
330: 'PV_ATTRIBUTE_CODES_VL CODE '||
331: 'WHERE '||

Line 351: 'PV_ATTRIBUTES_VL ATTR, '||

347: 'VAL.ATTR_VALUE_EXTN "attrValueExtn", '||
348: 'CODE.DESCRIPTION "CodeName", '||
349: 'VAL.LAST_UPDATE_DATE "date" ' ||
350: 'FROM ' ||
351: 'PV_ATTRIBUTES_VL ATTR, '||
352: 'PV_ENTY_ATTR_VALUES VAL, '||
353: 'PV_ENTITY_ATTRS ENTY, ' ||
354: 'PV_ATTRIBUTE_CODES_VL CODE '||
355: 'WHERE ' ||

Line 392: 'PV_ATTRIBUTES_VL ATTR, ' ||

388: 'VAL.LAST_UPDATE_DATE updateDate, ' ||
389: '(MAX(VAL.VERSION) OVER (PARTITION BY VAL.ATTRIBUTE_ID)) MaxVersion, ' ||
390: 'VAL.VERSION version ' ||
391: 'FROM ' ||
392: 'PV_ATTRIBUTES_VL ATTR, ' ||
393: 'PV_ENTY_ATTR_VALUES VAL, ' ||
394: 'PV_ENTITY_ATTRS ENTY, ' ||
395: 'PV_ATTRIBUTE_CODES_VL CODE ' ||
396: 'WHERE ' ||

Line 433: 'PV_ATTRIBUTES_VL ATTR, '||

429: ' "CodeName", ' ||
430:
431: 'VAL.LAST_UPDATE_DATE "date" '||
432: 'FROM '||
433: 'PV_ATTRIBUTES_VL ATTR, '||
434: 'PV_SEARCH_ATTR_VALUES VAL, '||
435: 'PV_ENTITY_ATTRS ENTY, '||
436: 'PV_ATTRIBUTE_CODES_VL CODE '||
437: 'WHERE '||

Line 485: FROM PV_ATTRIBUTES_VL attr, pv_entity_attrs enty

481: --l_attribute_type varchar2(30);
482:
483: CURSOR c_get_attr_details(cv_attribute_id NUMBER, pc_entity VARCHAR2) IS
484: SELECT attr.attribute_type,attr.decimal_points, enty.DISPLAY_EXTERNAL_VALUE_FLAG
485: FROM PV_ATTRIBUTES_VL attr, pv_entity_attrs enty
486: WHERE attr.attribute_id = cv_attribute_id and
487: attr.attribute_id= enty.attribute_id and
488: enty.entity=pc_entity
489: ;