[Home] [Help]
543: c.folder_id, f.folder_name, d.object_definition_id, d.display_name,
544: d.effective_start_date, d.effective_end_date,
545: sysdate, FND_GLOBAL.User_ID,
546: FND_GLOBAL.User_ID, sysdate, FND_GLOBAL.Login_ID
547: FROM fem_object_definition_vl d, fem_object_catalog_vl c,
548: fem_object_types_vl t, fem_folders_vl f
549: WHERE d.object_definition_id = p_obj_def_id
550: AND d.object_id = c.object_id
551: AND c.object_type_code = t.object_type_code
577: b.dimension_member, b.value_set_id, v.value_set_name,
578: sysdate, FND_GLOBAL.User_ID,
579: FND_GLOBAL.User_ID, sysdate, FND_GLOBAL.Login_ID
580: FROM fem_br_disabled_mbrs_gt b, FEM_LOOKUPS l, fem_value_sets_vl v,
581: fem_object_definition_vl d, fem_object_catalog_vl c,
582: fem_object_types_vl t, fem_folders_vl f, fem_dimensions_vl dim
583: WHERE b.object_definition_id = p_obj_def_id
584: AND b.object_definition_id = d.object_definition_id
585: AND d.object_id = c.object_id
1601: v_hier_flattened FEM_HIER_DEFINITIONS.
1602: FLATTENED_ROWS_COMPLETION_CODE%TYPE;
1603: v_hier_obj_id FEM_HIERARCHIES.HIERARCHY_OBJ_ID%TYPE;
1604: v_hier_obj_name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
1605: v_hier_obj_def_name FEM_OBJECT_DEFINITION_VL.DISPLAY_NAME%TYPE;
1606: v_mbr_disp_cd_col FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
1607: v_value_set_name FEM_VALUE_SETS_VL.VALUE_SET_NAME%TYPE;
1608: v_parent_disp_cd FEM_XDIM_DIMENSIONS.MEMBER_DISPLAY_CODE_COL%TYPE;
1609: v_parent_name FEM_OBJECT_CATALOG_VL.OBJECT_NAME%TYPE;
1646: h.flattened_rows_flag
1647: INTO v_dim_id, v_hier_obj_id, v_hier_obj_name, v_hier_obj_def_name,
1648: v_flat_flag
1649: FROM fem_hier_definitions d, fem_object_definition_b o,
1650: fem_object_definition_vl od,
1651: fem_object_catalog_b c, fem_hierarchies h, fem_object_catalog_vl a
1652: WHERE d.hierarchy_obj_def_id = p_obj_def_id
1653: AND d.hierarchy_obj_def_id = o.object_definition_id
1654: AND o.object_definition_id = od.object_definition_id