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.FUN_RECON_RPT_PKG dependencies on FUN_INTER_ACCOUNTS_V

Line 28: FROM fun_inter_accounts_v fia1,

24: ,fia1.ccid CCID
25: ,fia1.type ACCT_TYPE
26: ,gl1.accounted_period_type ACCOUNTED_PERIOD_TYPE
27: ,gl1.period_set_name PERIOD_SET_NAME
28: FROM fun_inter_accounts_v fia1,
29: fun_inter_accounts_v fia2,
30: gl_ledgers gl1,
31: xle_entity_profiles le1,
32: gl_ledgers gl2,

Line 29: fun_inter_accounts_v fia2,

25: ,fia1.type ACCT_TYPE
26: ,gl1.accounted_period_type ACCOUNTED_PERIOD_TYPE
27: ,gl1.period_set_name PERIOD_SET_NAME
28: FROM fun_inter_accounts_v fia1,
29: fun_inter_accounts_v fia2,
30: gl_ledgers gl1,
31: xle_entity_profiles le1,
32: gl_ledgers gl2,
33: xle_entity_profiles le2

Line 64: FROM fun_inter_accounts_v fia1,

60: ,gl2.name TRADING_PARTNER_LEDGER
61: ,glb1.currency_code TRANSACTION_CURRENCY
62: ,glb1.period_name TRANSACTING_PERIOD_NAME
63: ,glp2.period_name TRADING_PERIOD_NAME
64: FROM fun_inter_accounts_v fia1,
65: gl_balances glb1,
66: gl_ledgers gl1,
67: xle_entity_profiles le1,
68: gl_periods glp1,

Line 69: fun_inter_accounts_v fia2,

65: gl_balances glb1,
66: gl_ledgers gl1,
67: xle_entity_profiles le1,
68: gl_periods glp1,
69: fun_inter_accounts_v fia2,
70: gl_ledgers gl2,
71: xle_entity_profiles le2,
72: gl_periods glp2
73: WHERE fia1.ledger_id = glb1.ledger_id

Line 420: ,fun_inter_accounts_v fia

416: ,gl_je_lines gjl
417: ,gl_je_headers gjh
418: ,gl_je_batches gjb
419: ,gl_ledger_le_v glv
420: ,fun_inter_accounts_v fia
421: ,gl_periods glp
422: ,xla_subledgers xsrc
423: ,gl_ledgers gl
424: WHERE aeh.accounting_entry_status_code = ''F''

Line 566: ,fun_inter_accounts_v fia

562: ,gl_je_lines gjl
563: ,gl_je_headers gjh
564: ,gl_je_batches gjb
565: ,gl_ledger_le_v glv
566: ,fun_inter_accounts_v fia
567: ,gl_periods glp
568: WHERE gjh.je_header_id = gjl.je_header_id
569: AND gjb.je_batch_id = gjh.je_batch_id
570: AND gjb.status = ''P''

Line 617: ,fun_inter_accounts_v fia

613: ,gl_je_lines gjl
614: ,gl_je_headers gjh
615: ,gl_je_batches gjb
616: ,gl_ledger_le_v glv
617: ,fun_inter_accounts_v fia
618: ,gl_periods glp
619: ,xla_ae_headers aeh
620: ,xla_ae_lines ael
621: ,xla_events xle

Line 819: ,fun_inter_accounts_v fia

815: ,gl_je_lines gjl
816: ,gl_je_headers gjh
817: ,gl_je_batches gjb
818: ,gl_ledger_le_v glv
819: ,fun_inter_accounts_v fia
820: ,gl_periods glp
821: WHERE gjh.je_header_id = gjl.je_header_id
822: AND gjb.je_batch_id = gjh.je_batch_id
823: AND gjb.status = ''P''

Line 2003: FROM fun_inter_accounts_v fia

1999: AND glb.actual_flag = 'A'
2000: AND glb.currency_code = p_currency
2001: AND glb.translated_flag = 'R'
2002: AND glb.code_combination_id IN (SELECT DISTINCT fia.ccid
2003: FROM fun_inter_accounts_v fia
2004: WHERE fia.ledger_id = p_trans_ledger_id
2005: AND fia.from_le_id = p_trans_le_id
2006: AND fia.to_le_id = p_trad_le_id
2007: AND fia.type = 'R' );

Line 2022: FROM fun_inter_accounts_v fia

2018: AND glb.actual_flag = 'A'
2019: AND glb.currency_code = p_currency
2020: AND glb.translated_flag is NULL
2021: AND glb.code_combination_id IN (SELECT DISTINCT fia.ccid
2022: FROM fun_inter_accounts_v fia
2023: WHERE fia.ledger_id = p_trans_ledger_id
2024: AND fia.from_le_id = p_trans_le_id
2025: AND fia.to_le_id = p_trad_le_id
2026: AND fia.type = 'R' );

Line 2047: FROM fun_inter_accounts_v fia

2043: AND glb.actual_flag = 'A'
2044: AND glb.currency_code = p_currency
2045: AND glb.translated_flag = 'R'
2046: AND glb.code_combination_id IN (SELECT DISTINCT fia.ccid
2047: FROM fun_inter_accounts_v fia
2048: WHERE fia.ledger_id = p_trad_ledger_id
2049: AND fia.from_le_id = p_trad_le_id
2050: AND fia.to_le_id = p_trans_le_id
2051: AND fia.type = 'P' );

Line 2064: FROM fun_inter_accounts_v fia

2060: AND glb.actual_flag = 'A'
2061: AND glb.currency_code = p_currency
2062: AND glb.translated_flag is NULL
2063: AND glb.code_combination_id IN (SELECT DISTINCT fia.ccid
2064: FROM fun_inter_accounts_v fia
2065: WHERE fia.ledger_id = p_trad_ledger_id
2066: AND fia.from_le_id = p_trad_le_id
2067: AND fia.to_le_id = p_trans_le_id
2068: AND fia.type = 'P' );

Line 2215: ,fun_inter_accounts_v fia

2211: ,gl_je_lines gjl
2212: ,gl_je_headers gjh
2213: ,gl_je_batches gjb
2214: ,gl_ledger_le_v glv
2215: ,fun_inter_accounts_v fia
2216: ,gl_periods glp
2217:
2218: WHERE aeh.accounting_entry_status_code = 'F'
2219: AND aeh.gl_transfer_status_code = 'Y'

Line 2264: ,fun_inter_accounts_v fia

2260: ,gl_je_lines gjl
2261: ,gl_je_headers gjh
2262: ,gl_je_batches gjb
2263: ,gl_ledger_le_v glv
2264: ,fun_inter_accounts_v fia
2265: ,gl_periods glp
2266:
2267: WHERE aeh.accounting_entry_status_code = 'F'
2268: AND aeh.gl_transfer_status_code = 'Y'

Line 2316: ,fun_inter_accounts_v fia

2312: ,gl_je_lines gjl
2313: ,gl_je_headers gjh
2314: ,gl_je_batches gjb
2315: ,gl_ledger_le_v glv
2316: ,fun_inter_accounts_v fia
2317: ,gl_periods glp
2318:
2319: WHERE aeh.accounting_entry_status_code = 'F'
2320: AND aeh.gl_transfer_status_code = 'Y'

Line 2364: ,fun_inter_accounts_v fia

2360: ,gl_je_lines gjl
2361: ,gl_je_headers gjh
2362: ,gl_je_batches gjb
2363: ,gl_ledger_le_v glv
2364: ,fun_inter_accounts_v fia
2365: ,gl_periods glp
2366:
2367: WHERE aeh.accounting_entry_status_code = 'F'
2368: AND aeh.gl_transfer_status_code = 'Y'