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_INTERCO_MEMBERS

Line 97: INDEX(GIM GCS_INTERCO_MEMBERS_U1) USE_NL(GIET GIM)

93: , YTD_CREDIT_BALANCE_E , YTD_DEBIT_BALANCE_E
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

Line 118: GCS_INTERCO_MEMBERS gim,

114: giet.company_cost_center_org_id,
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

Line 185: INDEX(GIM GCS_INTERCO_MEMBERS_U1) USE_NL(GIET GIM)

181: , YTD_CREDIT_BALANCE_E , YTD_DEBIT_BALANCE_E
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

Line 206: GCS_INTERCO_MEMBERS gim,

202: giet.company_cost_center_org_id,
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

Line 277: INDEX(GIM GCS_INTERCO_MEMBERS_U1) USE_NL(GIET GIM)

273: , YTD_CREDIT_BALANCE_E , YTD_DEBIT_BALANCE_E
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

Line 298: GCS_INTERCO_MEMBERS gim,

294: giet.company_cost_center_org_id,
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

Line 368: INDEX(GIM GCS_INTERCO_MEMBERS_U1) USE_NL(GIET GIM)

364: , YTD_CREDIT_BALANCE_E , YTD_DEBIT_BALANCE_E
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

Line 389: GCS_INTERCO_MEMBERS gim,

385: giet.company_cost_center_org_id,
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

Line 462: INDEX(GIM GCS_INTERCO_MEMBERS_U1)

458: , DESCRIPTION, YTD_BALANCE_E, RECEIVABLES_ORG_ID,
459: PAYABLES_ORG_ID)
460: SELECT /*+ ORDERED FULL(GIHG)
461: INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
462: INDEX(GIM GCS_INTERCO_MEMBERS_U1)
463: INDEX (FB FEM_BALANCES_P)
464: USE_NL(GIET FB)*/
465: gihg.entry_id, giet.company_cost_center_org_id
466: , giet.line_item_id

Line 482: GCS_INTERCO_MEMBERS gim,

478: giet.company_cost_center_org_id,
479: giet.Intercompany_id)
480: FROM GCS_INTERCO_HDR_GT gihg,
481: GCS_INTERCO_ELM_TRX giet,
482: GCS_INTERCO_MEMBERS gim,
483: FEM_BALANCES fb
484: WHERE giet.cal_period_id = p_cal_period_id
485: AND giet.hierarchy_id = p_hierarchy_id
486: AND gihg.currency_code IN (p_currency_code,'STAT')

Line 504: GCS_INTERCO_MEMBERS gim2

500: AND fb.source_system_code = 70
501:
502: AND NOT EXISTS (SELECT 1
503: FROM GCS_INTERCO_ELM_TRX giet3,
504: GCS_INTERCO_MEMBERS gim2
505: WHERE giet3.hierarchy_id = p_hierarchy_id
506: AND giet3.cal_period_id = p_cal_period_id
507: AND giet3.src_entity_id = giet3.target_entity_id
508: AND giet3.src_entity_id = giet.src_entity_id

Line 560: INDEX(GIM GCS_INTERCO_MEMBERS_U1)

556: , DESCRIPTION , YTD_BALANCE_E,RECEIVABLES_ORG_ID,
557: PAYABLES_ORG_ID )
558: SELECT /*+ ORDERED FULL(GIHG)
559: INDEX(GIET GCS_INTERCO_ELM_TRX_U1)
560: INDEX(GIM GCS_INTERCO_MEMBERS_U1)
561: INDEX (FB FEM_BALANCES_P)
562: USE_NL(GIET FB)*/
563: gihg.entry_id, giet.company_cost_center_org_id
564: , giet.line_item_id

Line 580: GCS_INTERCO_MEMBERS gim,

576: giet.company_cost_center_org_id,
577: giet.Intercompany_id)
578: FROM GCS_INTERCO_HDR_GT gihg,
579: GCS_INTERCO_ELM_TRX giet,
580: GCS_INTERCO_MEMBERS gim,
581: FEM_BALANCES fb
582: WHERE giet.cal_period_id = p_cal_period_id
583: AND giet.hierarchy_id = p_hierarchy_id
584: AND gihg.currency_code IN (p_currency_code,'STAT')

Line 602: GCS_INTERCO_MEMBERS gim2

598: AND fb.source_system_code = 70
599:
600: AND NOT EXISTS (SELECT 1
601: FROM GCS_INTERCO_ELM_TRX giet3,
602: GCS_INTERCO_MEMBERS gim2
603: WHERE giet3.hierarchy_id = p_hierarchy_id
604: AND giet3.cal_period_id = p_cal_period_id
605: AND giet3.src_entity_id = giet3.target_entity_id
606: AND giet3.src_entity_id = giet.src_entity_id