DBA Data[Home] [Help]

APPS.PV_ENTY_ATTR_VALUE_PUB dependencies on PV_ATTRIBUTES_VL

Line 103: FROM PV_ATTRIBUTES_VL

99: latest_flag = 'Y';
100:
101: CURSOR c_get_attr_details(cv_attribute_id NUMBER) IS
102: SELECT attribute_type,display_style,DECIMAL_POINTS,name, character_width
103: FROM PV_ATTRIBUTES_VL
104: WHERE attribute_id = cv_attribute_id
105: ;
106:
107: CURSOR c_get_attr_enty_details (pc_attribute_id IN NUMBER, pc_entity IN VARCHAR2) IS

Line 1379: FROM PV_ATTRIBUTES_VL ATTR, PV_ENTITY_ATTRS ENTY, PV_ENTY_ATTR_VALUES VAL

1375: lc_ext_cursor cur_type;
1376:
1377: CURSOR c_attr_data_type(cv_attribute_id NUMBER, cv_entity_id NUMBER) IS
1378: SELECT distinct enty.attr_data_type, ENTY.SQL_TEXT -- VAL.version,
1379: FROM PV_ATTRIBUTES_VL ATTR, PV_ENTITY_ATTRS ENTY, PV_ENTY_ATTR_VALUES VAL
1380: WHERE ATTR.attribute_id = cv_attribute_id AND
1381: ENTY.ATTRIBUTE_ID = ATTR.attribute_id AND
1382: ENTY.ENTITY = 'PARTNER' AND
1383: VAL.ATTRIBUTE_ID (+) = ENTY.ATTRIBUTE_ID AND