DBA Data[Home] [Help]

APPS.ZPB_BUSAREA_VAL dependencies on FEM_LEDGERS_ATTR

Line 1044: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,

1040: if (l_fdr_id = -99) then
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'

Line 1058: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,

1054: else
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

Line 1171: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,

1167:
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'