APPS.ZPB_BUSAREA_VAL dependencies on FEM_DIM_ATTR_VERSIONS_B

Line 856: FEM_DIM_ATTR_VERSIONS_B B

852:
853: cursor c_attributes(p_logical_dim_id number) is
854: select A.ATTRIBUTE_ID, B.VERSION_ID, A.NAME
855: from ZPB_BUSAREA_ATTRIBUTES_VL A,
856: FEM_DIM_ATTR_VERSIONS_B B
857: where A.LOGICAL_DIM_ID = p_logical_dim_id
858: and A.VERSION_ID = p_version_id
859: and A.ATTRIBUTE_ID = B.ATTRIBUTE_ID
860: and B.DEFAULT_VERSION_FLAG = 'Y'

Line 1045: FEM_DIM_ATTR_VERSIONS_B E

1041: select count(distinct (C.DIM_ATTRIBUTE_NUMERIC_MEMBER))
1042: into l_count
1043: from ZPB_BUSAREA_LEDGERS B,
1044: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,
1045: FEM_DIM_ATTR_VERSIONS_B E
1046: where D.ATTRIBUTE_VARCHAR_LABEL = 'GLOBAL_VS_COMBO'
1047: and D.ATTRIBUTE_ID = E.ATTRIBUTE_ID
1048: and E.DEFAULT_VERSION_FLAG = 'Y'
1049: and E.AW_SNAPSHOT_FLAG = 'N'

Line 1059: FEM_DIM_ATTR_VERSIONS_B E,

1055: select count(distinct (C.DIM_ATTRIBUTE_NUMERIC_MEMBER))
1056: into l_count
1057: from ZPB_BUSAREA_LEDGERS B,
1058: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,
1059: FEM_DIM_ATTR_VERSIONS_B E,
1060: fem_object_definition_b objdef,fem_object_catalog_b obj
1061: where D.ATTRIBUTE_VARCHAR_LABEL = 'GLOBAL_VS_COMBO'
1062: and D.ATTRIBUTE_ID = E.ATTRIBUTE_ID
1063: and E.DEFAULT_VERSION_FLAG = 'Y'

Line 1172: FEM_DIM_ATTR_VERSIONS_B E

1168: select distinct (C.DIM_ATTRIBUTE_NUMERIC_MEMBER)
1169: into l_vs_combo_id
1170: from ZPB_BUSAREA_LEDGERS B,
1171: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,
1172: FEM_DIM_ATTR_VERSIONS_B E
1173: where D.ATTRIBUTE_VARCHAR_LABEL = 'GLOBAL_VS_COMBO'
1174: and D.ATTRIBUTE_ID = E.ATTRIBUTE_ID
1175: and E.DEFAULT_VERSION_FLAG = 'Y'
1176: and E.AW_SNAPSHOT_FLAG = 'N'

Line 1562: ''')) A, '||l_attr_table||' B, FEM_DIM_ATTR_VERSIONS_B C';

1558: l_command :=
1559: 'select count(*) '||
1560: 'from table(ZPB_FEM_UTILS_PKG.GET_HIERARCHY_MEMBERS('||
1561: each.LOGICAL_DIM_ID||', '||l_ba_id||', '''||l_vers_type||
1562: ''')) A, '||l_attr_table||' B, FEM_DIM_ATTR_VERSIONS_B C';
1563: if (l_vset_required = 'Y') then
1564: l_command := l_command||'
1565: where substr(A.CHILD_ID, instr(A.CHILD_ID, ''_'')+1) = B.'||
1566: l_col||' and substr(A.CHILD_ID, 1, '||

Line 1643: ' FEM_DIM_ATTR_VERSIONS_B E,';

1639: ' from FEM_DIM_ATTRIBUTES_B A,' ||
1640: ' '||l_dim_table||' B,' ||
1641: ' '||l_attr_table||' C,' ||
1642: ' FEM_DIM_ATTR_GRPS D,' ||
1643: ' FEM_DIM_ATTR_VERSIONS_B E,';
1644: if (l_no_hierarchies = 'Y') then
1645: l_command := l_command ||
1646: ' table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';
1647: l_command := l_command || ' '||l_org_dim_id||', '||l_org_logical_dim_id||', '||l_ba_id||', ''P'')) F';

Line 1745: ' FEM_DIM_ATTR_VERSIONS_B E,';

1741: ' MINUS select B.'||l_col||
1742: ' from FEM_DIM_ATTRIBUTES_B A,' ||
1743: ' '||l_dim_table||' B,' ||
1744: ' '||l_attr_table||' C,' ||
1745: ' FEM_DIM_ATTR_VERSIONS_B E,';
1746: if (l_no_hierarchies = 'Y') then
1747: l_command := l_command ||
1748: ' table(ZPB_FEM_UTILS_PKG.GET_LIST_DIM_MEMBERS(';
1749: l_command := l_command || ' '||l_org_dim_id||', '||l_org_logical_dim_id||', '||l_ba_id||', ''P'')) F';