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.PFT_PROFCAL_RGNCNT_PUB dependencies on FEM_CUSTOMERS_ATTR

Line 159: l_process_table VARCHAR2(30) := 'FEM_CUSTOMERS_ATTR';

155: IS
156:
157: l_api_name CONSTANT VARCHAR2(30) := 'Process_Single_Rule';
158:
159: l_process_table VARCHAR2(30) := 'FEM_CUSTOMERS_ATTR';
160: l_table_alias VARCHAR2(5) := 'FCA';
161: l_effective_date DATE;
162: l_dimension_grp_id NUMBER;
163: l_ds_where_clause LONG := NULL;

Line 363: FROM fem_customers_attr

359: FROM fem_customers_b
360: WHERE dimension_group_id = p_customer_level
361: AND value_set_id = l_value_set_id
362: AND customer_id NOT IN(SELECT customer_id
363: FROM fem_customers_attr
364: WHERE attribute_id = l_attribute_id);
365:
366: FEM_ENGINES_PKG.Tech_Message (
367: p_severity => g_log_level_3

Line 942: ' FEM_CUSTOMERS_ATTR fca , ' ||

938: l_user_id ||' , ' ||
939: l_request_id;
940:
941: l_from_stmt := ' FROM ' ||
942: ' FEM_CUSTOMERS_ATTR fca , ' ||
943: ' (' || ' SELECT dim_attr.attribute_id ' ||
944: ' FROM fem_dim_attributes_b dim_attr, ' ||
945: ' fem_dimensions_b xdim ' ||
946: ' WHERE dim_attr.dimension_id = xdim.dimension_id'||