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 GL_LEDGER_LE_V

Line 30: gl_ledger_le_v gl1,

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_ledger_le_v gl1,
31: gl_ledger_le_v gl2
32: WHERE fia1.ledger_id = gl1.ledger_id
33: AND fia1.from_le_id = gl1.legal_entity_id
34: AND fia1.to_le_id = fia2.from_le_id

Line 31: gl_ledger_le_v gl2

27: ,gl1.period_set_name PERIOD_SET_NAME
28: FROM fun_inter_accounts_v fia1,
29: fun_inter_accounts_v fia2,
30: gl_ledger_le_v gl1,
31: gl_ledger_le_v gl2
32: WHERE fia1.ledger_id = gl1.ledger_id
33: AND fia1.from_le_id = gl1.legal_entity_id
34: AND fia1.to_le_id = fia2.from_le_id
35: AND fia1.from_le_id = fia2.to_le_id

Line 62: gl_ledger_le_v gl1,

58: ,glb1.period_name TRANSACTING_PERIOD_NAME
59: ,glp2.period_name TRADING_PERIOD_NAME
60: FROM fun_inter_accounts_v fia1,
61: gl_balances glb1,
62: gl_ledger_le_v gl1,
63: gl_periods glp1,
64: fun_inter_accounts_v fia2,
65: gl_ledger_le_v gl2,
66: gl_periods glp2

Line 65: gl_ledger_le_v gl2,

61: gl_balances glb1,
62: gl_ledger_le_v gl1,
63: gl_periods glp1,
64: fun_inter_accounts_v fia2,
65: gl_ledger_le_v gl2,
66: gl_periods glp2
67: WHERE fia1.ledger_id = glb1.ledger_id
68: AND fia1.ccid = glb1.code_combination_id
69: AND fia1.type = ''R''

Line 401: ,gl_ledger_le_v glv

397: ,gl_import_references gir
398: ,gl_je_lines gjl
399: ,gl_je_headers gjh
400: ,gl_je_batches gjb
401: ,gl_ledger_le_v glv
402: ,fun_inter_accounts_v fia
403: ,gl_periods glp
404: ,xla_subledgers xsrc
405: WHERE aeh.accounting_entry_status_code = ''F''

Line 538: ,gl_ledger_le_v glv

534: ,gl_je_sources_tl gjst
535: ,gl_je_lines gjl
536: ,gl_je_headers gjh
537: ,gl_je_batches gjb
538: ,gl_ledger_le_v glv
539: ,fun_inter_accounts_v fia
540: ,gl_periods glp
541: WHERE gjh.je_header_id = gjl.je_header_id
542: AND gjb.je_batch_id = gjh.je_batch_id

Line 589: ,gl_ledger_le_v glv

585: ,gl_je_sources_tl gjst
586: ,gl_je_lines gjl
587: ,gl_je_headers gjh
588: ,gl_je_batches gjb
589: ,gl_ledger_le_v glv
590: ,fun_inter_accounts_v fia
591: ,gl_periods glp
592: ,xla_ae_headers aeh
593: ,xla_ae_lines ael

Line 791: ,gl_ledger_le_v glv

787: ,gl_daily_conversion_types gdct
788: ,gl_je_lines gjl
789: ,gl_je_headers gjh
790: ,gl_je_batches gjb
791: ,gl_ledger_le_v glv
792: ,fun_inter_accounts_v fia
793: ,gl_periods glp
794: WHERE gjh.je_header_id = gjl.je_header_id
795: AND gjb.je_batch_id = gjh.je_batch_id

Line 1479: FROM gl_ledger_le_v tole

1475: l_get_account_query := l_get_account_query || ' AND fia2.ledger_id = '||p_tp_ledger_id ;
1476:
1477:
1478: l_sum_unmatched_query := l_sum_unmatched_query || ' AND SRC_TRAD_LE_ID IN (SELECT tole.legal_entity_id
1479: FROM gl_ledger_le_v tole
1480: WHERE tole.ledger_id = '||p_tp_ledger_id ||')';
1481:
1482:
1483: l_gl_unmatched_query := l_gl_unmatched_query || ' AND fia.to_le_id IN (SELECT tole.legal_entity_id

Line 1484: FROM gl_ledger_le_v tole

1480: WHERE tole.ledger_id = '||p_tp_ledger_id ||')';
1481:
1482:
1483: l_gl_unmatched_query := l_gl_unmatched_query || ' AND fia.to_le_id IN (SELECT tole.legal_entity_id
1484: FROM gl_ledger_le_v tole
1485: WHERE tole.ledger_id = '||p_tp_ledger_id ||')';
1486:
1487: l_sla_unmatched_query := l_sla_unmatched_query || ' AND fia.to_le_id IN (SELECT tole.legal_entity_id
1488: FROM gl_ledger_le_v tole

Line 1488: FROM gl_ledger_le_v tole

1484: FROM gl_ledger_le_v tole
1485: WHERE tole.ledger_id = '||p_tp_ledger_id ||')';
1486:
1487: l_sla_unmatched_query := l_sla_unmatched_query || ' AND fia.to_le_id IN (SELECT tole.legal_entity_id
1488: FROM gl_ledger_le_v tole
1489: WHERE tole.ledger_id = '||p_tp_ledger_id ||')';
1490: END IF;
1491:
1492: IF P_TP_LEGAL_ENTITY_ID IS NOT NULL -- User input parameter

Line 1624: FROM gl_ledger_le_v tole

1620: l_get_account_query_rev := l_get_account_query_rev || ' AND fia2.ledger_id = '||p_trans_ledger_id;
1621:
1622:
1623: l_sum_unmatched_query_rev := l_sum_unmatched_query_rev || ' AND SRC_TRAD_LE_ID IN (SELECT tole.legal_entity_id
1624: FROM gl_ledger_le_v tole
1625: WHERE tole.ledger_id = '||p_trans_ledger_id ||')';
1626:
1627: l_gl_unmatched_query_rev := l_gl_unmatched_query_rev || ' AND fia.to_le_id IN (SELECT tole.legal_entity_id
1628: FROM gl_ledger_le_v tole

Line 1628: FROM gl_ledger_le_v tole

1624: FROM gl_ledger_le_v tole
1625: WHERE tole.ledger_id = '||p_trans_ledger_id ||')';
1626:
1627: l_gl_unmatched_query_rev := l_gl_unmatched_query_rev || ' AND fia.to_le_id IN (SELECT tole.legal_entity_id
1628: FROM gl_ledger_le_v tole
1629: WHERE tole.ledger_id = '||p_trans_ledger_id ||')';
1630:
1631: l_sla_unmatched_query_rev := l_sla_unmatched_query_rev || ' AND fia.to_le_id IN (SELECT tole.legal_entity_id
1632: FROM gl_ledger_le_v tole

Line 1632: FROM gl_ledger_le_v tole

1628: FROM gl_ledger_le_v tole
1629: WHERE tole.ledger_id = '||p_trans_ledger_id ||')';
1630:
1631: l_sla_unmatched_query_rev := l_sla_unmatched_query_rev || ' AND fia.to_le_id IN (SELECT tole.legal_entity_id
1632: FROM gl_ledger_le_v tole
1633: WHERE tole.ledger_id = '||p_trans_ledger_id ||')';
1634:
1635: END IF;
1636:

Line 1838: from gl_ledger_le_v

1834: v_le_name varchar2(100);
1835: BEGIN
1836: select distinct legal_entity_name
1837: into v_le_name
1838: from gl_ledger_le_v
1839: where legal_entity_id = p_le_id
1840: and rownum=1;
1841:
1842: return v_le_name;

Line 2108: ,gl_ledger_le_v glv

2104: ,gl_import_references gir
2105: ,gl_je_lines gjl
2106: ,gl_je_headers gjh
2107: ,gl_je_batches gjb
2108: ,gl_ledger_le_v glv
2109: ,fun_inter_accounts_v fia
2110: ,gl_periods glp
2111:
2112: WHERE aeh.accounting_entry_status_code = 'F'

Line 2157: ,gl_ledger_le_v glv

2153: ,gl_import_references gir
2154: ,gl_je_lines gjl
2155: ,gl_je_headers gjh
2156: ,gl_je_batches gjb
2157: ,gl_ledger_le_v glv
2158: ,fun_inter_accounts_v fia
2159: ,gl_periods glp
2160:
2161: WHERE aeh.accounting_entry_status_code = 'F'

Line 2209: ,gl_ledger_le_v glv

2205: ,gl_import_references gir
2206: ,gl_je_lines gjl
2207: ,gl_je_headers gjh
2208: ,gl_je_batches gjb
2209: ,gl_ledger_le_v glv
2210: ,fun_inter_accounts_v fia
2211: ,gl_periods glp
2212:
2213: WHERE aeh.accounting_entry_status_code = 'F'

Line 2257: ,gl_ledger_le_v glv

2253: ,gl_import_references gir
2254: ,gl_je_lines gjl
2255: ,gl_je_headers gjh
2256: ,gl_je_batches gjb
2257: ,gl_ledger_le_v glv
2258: ,fun_inter_accounts_v fia
2259: ,gl_periods glp
2260:
2261: WHERE aeh.accounting_entry_status_code = 'F'