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.GCS_INTERCO_DYNAMIC_PKG dependencies on FEM_USER_DIM1_HIER

Line 1255: FROM fem_user_dim1_hier fcch1,

1251: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').version_id
1252:
1253: AND fcca.user_dim1_id = (
1254: SELECT fcch1.parent_id
1255: FROM fem_user_dim1_hier fcch1,
1256: fem_user_dim1_hier fcch2
1257: WHERE fcch1.child_id =
1258: fcoa2.dim_attribute_numeric_member
1259: AND fcch1.hierarchy_obj_def_id =

Line 1256: fem_user_dim1_hier fcch2

1252:
1253: AND fcca.user_dim1_id = (
1254: SELECT fcch1.parent_id
1255: FROM fem_user_dim1_hier fcch1,
1256: fem_user_dim1_hier fcch2
1257: WHERE fcch1.child_id =
1258: fcoa2.dim_attribute_numeric_member
1259: AND fcch1.hierarchy_obj_def_id =
1260: l_valid_hierarchy_id

Line 1272: FROM fem_user_dim1_hier fcch3,

1268: -- *** To eliminte self rows
1269: AND fcch1.parent_id = fcch2.parent_id
1270: AND fcch1.parent_depth_num =
1271: (SELECT MAX(fcch3.parent_depth_num)
1272: FROM fem_user_dim1_hier fcch3,
1273: fem_user_dim1_hier fcch4
1274: WHERE fcch3.child_id =
1275: fcoa2.dim_attribute_numeric_member
1276: AND fcch3.hierarchy_obj_def_id =

Line 1273: fem_user_dim1_hier fcch4

1269: AND fcch1.parent_id = fcch2.parent_id
1270: AND fcch1.parent_depth_num =
1271: (SELECT MAX(fcch3.parent_depth_num)
1272: FROM fem_user_dim1_hier fcch3,
1273: fem_user_dim1_hier fcch4
1274: WHERE fcch3.child_id =
1275: fcoa2.dim_attribute_numeric_member
1276: AND fcch3.hierarchy_obj_def_id =
1277: l_valid_hierarchy_id

Line 1398: FROM fem_user_dim1_hier fcch1,

1394: AND fcca.version_id = gcs_utility_pkg.g_dimension_attr_info('USER_DIM1_ID-ELIMINATION_LOB').version_id
1395:
1396: AND fcca.user_dim1_id = (
1397: SELECT fcch1.parent_id
1398: FROM fem_user_dim1_hier fcch1,
1399: fem_user_dim1_hier fcch2
1400: WHERE fcch1.child_id =
1401: fcoa2.dim_attribute_numeric_member
1402: AND fcch1.hierarchy_obj_def_id =

Line 1399: fem_user_dim1_hier fcch2

1395:
1396: AND fcca.user_dim1_id = (
1397: SELECT fcch1.parent_id
1398: FROM fem_user_dim1_hier fcch1,
1399: fem_user_dim1_hier fcch2
1400: WHERE fcch1.child_id =
1401: fcoa2.dim_attribute_numeric_member
1402: AND fcch1.hierarchy_obj_def_id =
1403: l_valid_hierarchy_id

Line 1415: FROM fem_user_dim1_hier fcch3,

1411: -- *** To eliminte self rows
1412: AND fcch1.parent_id = fcch2.parent_id
1413: AND fcch1.parent_depth_num =
1414: (SELECT MAX(fcch3.parent_depth_num)
1415: FROM fem_user_dim1_hier fcch3,
1416: fem_user_dim1_hier fcch4
1417: WHERE fcch3.child_id =
1418: fcoa2.dim_attribute_numeric_member
1419: AND fcch3.hierarchy_obj_def_id =

Line 1416: fem_user_dim1_hier fcch4

1412: AND fcch1.parent_id = fcch2.parent_id
1413: AND fcch1.parent_depth_num =
1414: (SELECT MAX(fcch3.parent_depth_num)
1415: FROM fem_user_dim1_hier fcch3,
1416: fem_user_dim1_hier fcch4
1417: WHERE fcch3.child_id =
1418: fcoa2.dim_attribute_numeric_member
1419: AND fcch3.hierarchy_obj_def_id =
1420: l_valid_hierarchy_id