APPS.PV_ATTRIBUTE_UTIL dependencies on PV_ENTITY_ATTRS

Line 85: 'PV_ENTITY_ATTRS ENTY, ' ||

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 ' ||
88: 'ATTR.ATTRIBUTE_ID = :1 AND ' ||
89: 'ATTR.ATTRIBUTE_ID = ENTY.ATTRIBUTE_ID AND ' ||

Line 294: 'PV_ENTITY_ATTRS ENTY, '||

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 '||
297: 'ATTR.ATTRIBUTE_ID = :1 AND '||
298: 'ATTR.ATTRIBUTE_ID = ENTY.ATTRIBUTE_ID AND '||

Line 329: 'PV_ENTITY_ATTRS ENTY, '||

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 '||
332: 'ATTR.ATTRIBUTE_ID = :4 AND '||
333: 'ATTR.ATTRIBUTE_ID = ENTY.ATTRIBUTE_ID AND '||

Line 353: 'PV_ENTITY_ATTRS ENTY, ' ||

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 ' ||
356: 'ATTR.ATTRIBUTE_ID = :1 AND ' ||
357: 'ATTR.ATTRIBUTE_ID = ENTY.ATTRIBUTE_ID AND ' ||

Line 394: 'PV_ENTITY_ATTRS ENTY, ' ||

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 ' ||
397: 'ATTR.ATTRIBUTE_ID = :1 AND ' ||
398: 'ATTR.ATTRIBUTE_ID = ENTY.ATTRIBUTE_ID AND ' ||

Line 435: 'PV_ENTITY_ATTRS ENTY, '||

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 '||
438: 'ATTR.ATTRIBUTE_ID = :6 AND '||
439: 'ATTR.ATTRIBUTE_ID = ENTY.ATTRIBUTE_ID AND '||

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: ;