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.FII_AR_REVENUE_B_C dependencies on FII_SOURCE_LEDGER_GROUPS

Line 70: fii_source_ledger_groups fslg

66: fa_deprn_periods dp,
67: fa_book_controls bc,
68: (SELECT DISTINCT slga.ledger_id
69: FROM fii_slg_assignments slga,
70: fii_source_ledger_groups fslg
71: WHERE slga.source_ledger_group_id = fslg.source_ledger_group_id
72: AND fslg.usage_code = g_usage_code) fset
73: WHERE s.ledger_id = fset.ledger_id
74: AND ps.application_id = 101

Line 91: fii_source_ledger_groups fslg

87: FROM gl_period_statuses ps,
88: gl_ledgers_public_v s,
89: (SELECT DISTINCT slga.ledger_id
90: FROM fii_slg_assignments slga,
91: fii_source_ledger_groups fslg
92: WHERE slga.source_ledger_group_id = fslg.source_ledger_group_id
93: AND fslg.usage_code =g_usage_code) fset
94: WHERE s.ledger_id = fset.ledger_id
95: AND ps.application_id = 200

Line 109: fii_source_ledger_groups fslg

105: FROM gl_period_statuses ps,
106: gl_ledgers_public_v s,
107: (SELECT DISTINCT slga.ledger_id
108: FROM fii_slg_assignments slga,
109: fii_source_ledger_groups fslg
110: WHERE slga.source_ledger_group_id = fslg.source_ledger_group_id
111: AND fslg.usage_code = g_usage_code) fset
112: WHERE s.ledger_id = fset.ledger_id
113: AND ps.application_id = 222

Line 586: fii_source_ledger_groups fslg,

582: ra_cust_trx_line_gl_dist_all ctlgd,
583: gl_code_combinations glcc,
584: fii_gl_ccid_dimensions ccdim,
585: fii_slg_assignments slga,
586: fii_source_ledger_groups fslg,
587: -- fii_fin_cat_type_assgns ffcta,
588: ra_customer_trx_lines_all ctl_parent,
589: gl_ledgers_public_v sob,
590: hz_cust_accounts bill_acct,

Line 861: fii_source_ledger_groups fslg,

857: ar_distributions_all ad,
858: gl_code_combinations gcc,
859: fii_gl_ccid_dimensions ccdim,
860: fii_slg_assignments slga,
861: fii_source_ledger_groups fslg,
862: -- fii_fin_cat_type_assgns ffcta,
863: ra_customer_trx_all ct,
864: -- ra_customer_trx_lines_all ctl,
865: -- ra_customer_trx_lines_all ctl_parent,

Line 1129: from fii_source_ledger_groups fslg,

1125: ccdim.natural_account_id y_natural_account_id,
1126: ccdim.prod_category_id y_prod_category_id,
1127: slga.ledger_id y_ledger_id
1128: -- ffcta.fin_cat_type_code y_fin_cat_type_code
1129: from fii_source_ledger_groups fslg,
1130: fii_slg_assignments slga,
1131: fii_gl_ccid_dimensions ccdim
1132: -- fii_fin_cat_type_assgns ffcta
1133: where (slga.bal_seg_value_id = ccdim.company_id

Line 1782: fii_source_ledger_groups fslg

1778: from ra_customer_trx_all t,
1779: ar_adjustments_all adj,
1780: ( select distinct ledger_id
1781: from fii_slg_assignments slga,
1782: fii_source_ledger_groups fslg
1783: where slga.source_ledger_group_id = fslg.source_ledger_group_id
1784: and fslg.usage_code = :a
1785: ) lidset
1786: WHERE t.complete_flag = ''Y''

Line 1818: fii_source_ledger_groups fslg

1814: t.adjustment_id
1815: FROM ar_adjustments_all t,
1816: ( select distinct ledger_id
1817: from fii_slg_assignments slga,
1818: fii_source_ledger_groups fslg
1819: where slga.source_ledger_group_id = fslg.source_ledger_group_id
1820: AND fslg.usage_code = :a
1821: ) lidset
1822: WHERE t.gl_date BETWEEN to_date(:b,''YYYY/MM/DD HH24:MI:SS'') AND to_date(:c,''YYYY/MM/DD HH24:MI:SS'')

Line 1860: fii_source_ledger_groups fslg

1856: FROM ra_customer_trx_all ct,
1857: ra_customer_trx_lines_all ctl,
1858: ( select distinct ledger_id
1859: from fii_slg_assignments slga,
1860: fii_source_ledger_groups fslg
1861: where slga.source_ledger_group_id = fslg.source_ledger_group_id
1862: and fslg.usage_code = :a
1863: ) lidset
1864: WHERE ct.last_update_date between to_date(:b,''YYYY/MM/DD HH24:MI:SS'') and to_date(:c,''YYYY/MM/DD HH24:MI:SS'')

Line 1875: fii_source_ledger_groups fslg

1871: ct.customer_trx_line_id
1872: FROM ra_customer_trx_lines_all ct,
1873: ( select distinct ledger_id
1874: from fii_slg_assignments slga,
1875: fii_source_ledger_groups fslg
1876: where slga.source_ledger_group_id = fslg.source_ledger_group_id
1877: and fslg.usage_code = :d
1878: ) lidset
1879: WHERE nvl(ct.interface_line_context, ''xxx'') NOT IN (''PA INVOICES'')

Line 1926: fii_source_ledger_groups fslg

1922: aeh.ae_header_id
1923: FROM xla_ae_headers aeh,
1924: ( select /*+ no_merge */ distinct ledger_id
1925: from fii_slg_assignments slga,
1926: fii_source_ledger_groups fslg
1927: where slga.source_ledger_group_id = fslg.source_ledger_group_id
1928: and fslg.usage_code = :m
1929: ) lidset,
1930: ( select 8 view_type_id from dual

Line 1963: fii_source_ledger_groups fslg

1959: aeh.ae_header_id
1960: FROM xla_ae_headers aeh,
1961: ( select distinct ledger_id
1962: from fii_slg_assignments slga,
1963: fii_source_ledger_groups fslg
1964: where slga.source_ledger_group_id = fslg.source_ledger_group_id
1965: and fslg.usage_code = :a
1966: ) lidset,
1967: ( select 8 view_type_id from dual

Line 3266: FROM (select /+ PARALLEL(a) / * from fii_source_ledger_groups a) fslg,

3262: decode(sh.booked_flag, 'Y', trunc(nvl(sl_child.order_firmed_date,
3263: sh.booked_date)), to_date(null)) REV_BOOKED_DATE,
3264: decode(ctl.interface_line_context, 'ORDER ENTRY',ctl.interface_line_attribute6,
3265: null) CHILD_ORDER_LINE_ID
3266: FROM (select /*+ PARALLEL(a) */ * from fii_source_ledger_groups a) fslg,
3267: (select /*+ PARALLEL(a) */ * from fii_slg_assignments a) slga,
3268: (select /*+ PARALLEL(a) */ * from fii_gl_ccid_dimensions a) ccdim,
3269: -- (select /*+ PARALLEL(a) */ * from fii_fin_cat_type_assgns a) ffcta,
3270: (select /*+ PARALLEL(a) */ * from gl_code_combinations a) gcc,

Line 3292: from fii_slg_assignments slga, fii_source_ledger_groups fslg

3288: FROM ar_adjustments_all adj,
3289: ar_distributions_all ad,
3290: (
3291: select /*+ no_merge use_hash(slga,fslg) */ distinct ledger_id
3292: from fii_slg_assignments slga, fii_source_ledger_groups fslg
3293: where slga.source_ledger_group_id = fslg.source_ledger_group_id
3294: and fslg.usage_code = g_usage_code
3295: ) lidset,
3296: ACCNT_CLASS AC,

Line 3349: from fii_slg_assignments slga, fii_source_ledger_groups fslg

3345: AC.Fin_Cat_Type_Code
3346: FROM ra_cust_trx_line_gl_dist_all ctlgd,
3347: (
3348: select /*+ no_merge use_hash(slga,fslg) */ distinct ledger_id
3349: from fii_slg_assignments slga, fii_source_ledger_groups fslg
3350: where slga.source_ledger_group_id = fslg.source_ledger_group_id
3351: and fslg.usage_code = g_usage_code
3352: ) lidset,
3353: ACCNT_CLASS AC,

Line 3960: fii_source_ledger_groups fslg

3956: SELECT trunc(min(stu.start_date))
3957: INTO l_gl_from_date1
3958: FROM gl_period_statuses stu,
3959: fii_slg_assignments slga,
3960: fii_source_ledger_groups fslg
3961: WHERE slga.ledger_id = stu.set_of_books_id
3962: AND slga.source_ledger_group_id = fslg.source_ledger_group_id
3963: AND fslg.usage_code = g_usage_code
3964: AND stu.application_id = 222

Line 4014: fii_source_ledger_groups fslg

4010: SELECT trunc(min(stu.start_date))
4011: INTO l_gl_from_date2
4012: FROM gl_period_statuses stu,
4013: fii_slg_assignments slga,
4014: fii_source_ledger_groups fslg
4015: WHERE slga.ledger_id = stu.set_of_books_id
4016: AND slga.source_ledger_group_id = fslg.source_ledger_group_id
4017: AND fslg.usage_code = g_usage_code
4018: AND stu.application_id = 222