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 GCS_CONS_RELATIONSHIPS

Line 98: INDEX(GCR GCS_CONS_RELATIONSHIPS_N1)

94: , DESCRIPTION, YTD_BALANCE_E, RECEIVABLES_ORG_ID,
95: PAYABLES_ORG_ID )
96: SELECT /*+ ORDERED FULL(GIHG) INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
97: INDEX(GIM GCS_INTERCO_MEMBERS_U1) USE_NL(GIET GIM)
98: INDEX(GCR GCS_CONS_RELATIONSHIPS_N1)
99: INDEX (FB FEM_BALANCES_P)
100: USE_NL(GCR FB)*/
101: gihg.entry_id, giet.company_cost_center_org_id
102: , giet.line_item_id

Line 119: GCS_CONS_RELATIONSHIPS gcr,

115: giet.Intercompany_id)
116: FROM GCS_INTERCO_HDR_GT gihg,
117: GCS_INTERCO_ELM_TRX giet,
118: GCS_INTERCO_MEMBERS gim,
119: GCS_CONS_RELATIONSHIPS gcr,
120: FEM_BALANCES fb
121: WHERE giet.cal_period_id = p_cal_period_id
122: AND giet.hierarchy_id = p_hierarchy_id
123: AND gihg.currency_code IN (p_currency_code,'STAT')

Line 186: INDEX(GCR GCS_CONS_RELATIONSHIPS_N1)

182: , DESCRIPTION, YTD_BALANCE_E, RECEIVABLES_ORG_ID,
183: PAYABLES_ORG_ID )
184: SELECT /*+ ORDERED FULL(GIHG) INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
185: INDEX(GIM GCS_INTERCO_MEMBERS_U1) USE_NL(GIET GIM)
186: INDEX(GCR GCS_CONS_RELATIONSHIPS_N1)
187: INDEX (FB FEM_BALANCES_P)
188: USE_NL(GCR FB)*/
189: gihg.entry_id, giet.company_cost_center_org_id
190: , giet.line_item_id

Line 207: GCS_CONS_RELATIONSHIPS gcr,

203: giet.Intercompany_id)
204: FROM GCS_INTERCO_HDR_GT gihg,
205: GCS_INTERCO_ELM_TRX giet,
206: GCS_INTERCO_MEMBERS gim,
207: GCS_CONS_RELATIONSHIPS gcr,
208: FEM_BALANCES fb
209: WHERE giet.cal_period_id = p_cal_period_id
210: AND giet.hierarchy_id = p_hierarchy_id
211: AND gihg.currency_code IN (p_currency_code,'STAT')

Line 278: INDEX(GCR GCS_CONS_RELATIONSHIPS_N1)

274: , DESCRIPTION ,YTD_BALANCE_E, RECEIVABLES_ORG_ID,
275: PAYABLES_ORG_ID)
276: SELECT /*+ ORDERED FULL(GIHG) INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
277: INDEX(GIM GCS_INTERCO_MEMBERS_U1) USE_NL(GIET GIM)
278: INDEX(GCR GCS_CONS_RELATIONSHIPS_N1)
279: INDEX (FB FEM_BALANCES_P)
280: USE_NL(GCR FB)*/
281: gihg.entry_id, giet.company_cost_center_org_id
282: , giet.line_item_id

Line 299: GCS_CONS_RELATIONSHIPS gcr,

295: giet.Intercompany_id)
296: FROM GCS_INTERCO_HDR_GT gihg,
297: GCS_INTERCO_ELM_TRX giet,
298: GCS_INTERCO_MEMBERS gim,
299: GCS_CONS_RELATIONSHIPS gcr,
300: FEM_BALANCES fb
301: WHERE giet.cal_period_id = p_cal_period_id
302: AND giet.hierarchy_id = p_hierarchy_id
303: AND gihg.currency_code IN (p_currency_code,'STAT')

Line 369: INDEX(GCR GCS_CONS_RELATIONSHIPS_N1)

365: , DESCRIPTION ,YTD_BALANCE_E, RECEIVABLES_ORG_ID,
366: PAYABLES_ORG_ID)
367: SELECT /*+ ORDERED FULL(GIHG) INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
368: INDEX(GIM GCS_INTERCO_MEMBERS_U1) USE_NL(GIET GIM)
369: INDEX(GCR GCS_CONS_RELATIONSHIPS_N1)
370: INDEX (FB FEM_BALANCES_P)
371: USE_NL(GCR FB)*/
372: gihg.entry_id, giet.company_cost_center_org_id
373: , giet.line_item_id

Line 390: GCS_CONS_RELATIONSHIPS gcr,

386: giet.Intercompany_id)
387: FROM GCS_INTERCO_HDR_GT gihg,
388: GCS_INTERCO_ELM_TRX giet,
389: GCS_INTERCO_MEMBERS gim,
390: GCS_CONS_RELATIONSHIPS gcr,
391: FEM_BALANCES fb
392: WHERE giet.cal_period_id = p_cal_period_id
393: AND giet.hierarchy_id = p_hierarchy_id
394: AND gihg.currency_code IN (p_currency_code,'STAT')

Line 1212: GCS_CONS_RELATIONSHIPS gcr,

1208: FROM GCS_ENTRY_HEADERS geh,
1209: GCS_ENTRY_LINES gel,
1210: GCS_ENTITY_CCTR_ORGS geo,
1211: GCS_ENTITY_CCTR_ORGS geo1,
1212: GCS_CONS_RELATIONSHIPS gcr,
1213: GCS_CONS_RELATIONSHIPS gcr1,
1214: fem_cctr_orgs_attr fcoa2,
1215: fem_cctr_orgs_attr fcoa3,
1216: fem_user_dim1_attr fcca

Line 1213: GCS_CONS_RELATIONSHIPS gcr1,

1209: GCS_ENTRY_LINES gel,
1210: GCS_ENTITY_CCTR_ORGS geo,
1211: GCS_ENTITY_CCTR_ORGS geo1,
1212: GCS_CONS_RELATIONSHIPS gcr,
1213: GCS_CONS_RELATIONSHIPS gcr1,
1214: fem_cctr_orgs_attr fcoa2,
1215: fem_cctr_orgs_attr fcoa3,
1216: fem_user_dim1_attr fcca
1217: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)

Line 1355: GCS_CONS_RELATIONSHIPS gcr,

1351: FROM GCS_ENTRY_HEADERS geh,
1352: GCS_ENTRY_LINES gel,
1353: GCS_ENTITY_CCTR_ORGS geo,
1354: GCS_ENTITY_CCTR_ORGS geo1,
1355: GCS_CONS_RELATIONSHIPS gcr,
1356: GCS_CONS_RELATIONSHIPS gcr1,
1357: fem_cctr_orgs_attr fcoa2,
1358: fem_cctr_orgs_attr fcoa3,
1359: fem_user_dim1_attr fcca

Line 1356: GCS_CONS_RELATIONSHIPS gcr1,

1352: GCS_ENTRY_LINES gel,
1353: GCS_ENTITY_CCTR_ORGS geo,
1354: GCS_ENTITY_CCTR_ORGS geo1,
1355: GCS_CONS_RELATIONSHIPS gcr,
1356: GCS_CONS_RELATIONSHIPS gcr1,
1357: fem_cctr_orgs_attr fcoa2,
1358: fem_cctr_orgs_attr fcoa3,
1359: fem_user_dim1_attr fcca
1360: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)

Line 1498: GCS_CONS_RELATIONSHIPS gcr,

1494: FROM GCS_ENTRY_HEADERS geh,
1495: GCS_ENTRY_LINES gel,
1496: GCS_ENTITY_CCTR_ORGS geo,
1497: GCS_ENTITY_CCTR_ORGS geo1,
1498: GCS_CONS_RELATIONSHIPS gcr,
1499: GCS_CONS_RELATIONSHIPS gcr1
1500: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)
1501: AND geh.entry_id = gel.entry_id
1502: AND gel.intercompany_id <> x_specific_intercompany_id

Line 1499: GCS_CONS_RELATIONSHIPS gcr1

1495: GCS_ENTRY_LINES gel,
1496: GCS_ENTITY_CCTR_ORGS geo,
1497: GCS_ENTITY_CCTR_ORGS geo1,
1498: GCS_CONS_RELATIONSHIPS gcr,
1499: GCS_CONS_RELATIONSHIPS gcr1
1500: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)
1501: AND geh.entry_id = gel.entry_id
1502: AND gel.intercompany_id <> x_specific_intercompany_id
1503: AND gel.intercompany_id =

Line 1585: GCS_CONS_RELATIONSHIPS gcr,

1581: FROM GCS_ENTRY_HEADERS geh,
1582: GCS_ENTRY_LINES gel,
1583: GCS_ENTITY_CCTR_ORGS geo,
1584: GCS_ENTITY_CCTR_ORGS geo1,
1585: GCS_CONS_RELATIONSHIPS gcr,
1586: GCS_CONS_RELATIONSHIPS gcr1
1587: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)
1588: AND geh.entry_id = gel.entry_id
1589: AND gel.intercompany_id <> gel.company_cost_center_org_id

Line 1586: GCS_CONS_RELATIONSHIPS gcr1

1582: GCS_ENTRY_LINES gel,
1583: GCS_ENTITY_CCTR_ORGS geo,
1584: GCS_ENTITY_CCTR_ORGS geo1,
1585: GCS_CONS_RELATIONSHIPS gcr,
1586: GCS_CONS_RELATIONSHIPS gcr1
1587: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)
1588: AND geh.entry_id = gel.entry_id
1589: AND gel.intercompany_id <> gel.company_cost_center_org_id
1590: AND gel.intercompany_id =

Line 1679: GCS_CONS_RELATIONSHIPS gcr,

1675: FROM GCS_ENTRY_HEADERS geh,
1676: GCS_ENTRY_LINES gel,
1677: GCS_ENTITY_CCTR_ORGS geo,
1678: GCS_ENTITY_CCTR_ORGS geo1,
1679: GCS_CONS_RELATIONSHIPS gcr,
1680: GCS_CONS_RELATIONSHIPS gcr1,
1681: fem_cctr_orgs_attr fcoa2,
1682: fem_cctr_orgs_attr fcoa3
1683: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)

Line 1680: GCS_CONS_RELATIONSHIPS gcr1,

1676: GCS_ENTRY_LINES gel,
1677: GCS_ENTITY_CCTR_ORGS geo,
1678: GCS_ENTITY_CCTR_ORGS geo1,
1679: GCS_CONS_RELATIONSHIPS gcr,
1680: GCS_CONS_RELATIONSHIPS gcr1,
1681: fem_cctr_orgs_attr fcoa2,
1682: fem_cctr_orgs_attr fcoa3
1683: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)
1684: AND geh.entry_id = gel.entry_id

Line 1791: GCS_CONS_RELATIONSHIPS gcr,

1787: FROM GCS_ENTRY_HEADERS geh,
1788: GCS_ENTRY_LINES gel,
1789: GCS_ENTITY_CCTR_ORGS geo,
1790: GCS_ENTITY_CCTR_ORGS geo1,
1791: GCS_CONS_RELATIONSHIPS gcr,
1792: GCS_CONS_RELATIONSHIPS gcr1,
1793: fem_cctr_orgs_attr fcoa2,
1794: fem_cctr_orgs_attr fcoa3
1795: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)

Line 1792: GCS_CONS_RELATIONSHIPS gcr1,

1788: GCS_ENTRY_LINES gel,
1789: GCS_ENTITY_CCTR_ORGS geo,
1790: GCS_ENTITY_CCTR_ORGS geo1,
1791: GCS_CONS_RELATIONSHIPS gcr,
1792: GCS_CONS_RELATIONSHIPS gcr1,
1793: fem_cctr_orgs_attr fcoa2,
1794: fem_cctr_orgs_attr fcoa3
1795: WHERE geh.entry_id IN (p_entry_id, p_stat_entry_id)
1796: AND geh.entry_id = gel.entry_id