1178: gib.sus_user_dim6_id, gib.sus_user_dim7_id,
1179: gib.sus_user_dim8_id, gib.sus_user_dim9_id,
1180: gib.sus_user_dim10_id, fc.currency_code
1181: FROM GCS_INTERCO_ELM_TRX giet,
1182: GCS_FLATTENED_RELNS gfr,
1183: GCS_FLATTENED_RELNS gfr1,
1184: GCS_INTERCO_MEMBERS gim,
1185: GCS_INTERCO_RULES_B gib ,
1186: FND_CURRENCIES fc
1179: gib.sus_user_dim8_id, gib.sus_user_dim9_id,
1180: gib.sus_user_dim10_id, fc.currency_code
1181: FROM GCS_INTERCO_ELM_TRX giet,
1182: GCS_FLATTENED_RELNS gfr,
1183: GCS_FLATTENED_RELNS gfr1,
1184: GCS_INTERCO_MEMBERS gim,
1185: GCS_INTERCO_RULES_B gib ,
1186: FND_CURRENCIES fc
1187: WHERE giet.hierarchy_id = p_hierarchy_id
1311: gib.sus_user_dim6_id, gib.sus_user_dim7_id,
1312: gib.sus_user_dim8_id, gib.sus_user_dim9_id,
1313: gib.sus_user_dim10_id, fc.currency_code
1314: FROM GCS_INTERCO_ELM_TRX giet,
1315: GCS_FLATTENED_RELNS gfr,
1316: GCS_FLATTENED_RELNS gfr1,
1317: GCS_INTERCO_MEMBERS gim,
1318: GCS_INTERCO_RULES_B gib ,
1319: FND_CURRENCIES fc
1312: gib.sus_user_dim8_id, gib.sus_user_dim9_id,
1313: gib.sus_user_dim10_id, fc.currency_code
1314: FROM GCS_INTERCO_ELM_TRX giet,
1315: GCS_FLATTENED_RELNS gfr,
1316: GCS_FLATTENED_RELNS gfr1,
1317: GCS_INTERCO_MEMBERS gim,
1318: GCS_INTERCO_RULES_B gib ,
1319: FND_CURRENCIES fc
1320: WHERE giet.hierarchy_id = p_hierarchy_id