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 419: ,gl_ledger_le_v glv

415: ,gl_import_references gir
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

Line 565: ,gl_ledger_le_v glv

561: ,gl_je_sources_tl gjst
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

Line 616: ,gl_ledger_le_v glv

612: ,gl_je_sources_tl gjst
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

Line 818: ,gl_ledger_le_v glv

814: ,gl_daily_conversion_types gdct
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

Line 1506: FROM gl_ledger_le_v tole

1502: l_get_account_query := l_get_account_query || ' AND fia2.ledger_id = '||p_tp_ledger_id ;
1503:
1504:
1505: l_sum_unmatched_query := l_sum_unmatched_query || ' AND SRC_TRAD_LE_ID IN (SELECT tole.legal_entity_id
1506: FROM gl_ledger_le_v tole
1507: WHERE tole.ledger_id = '||p_tp_ledger_id ||')';
1508:
1509:
1510: l_gl_unmatched_query := l_gl_unmatched_query || ' AND fia.to_le_id IN (SELECT tole.legal_entity_id

Line 1511: FROM gl_ledger_le_v tole

1507: WHERE tole.ledger_id = '||p_tp_ledger_id ||')';
1508:
1509:
1510: l_gl_unmatched_query := l_gl_unmatched_query || ' AND fia.to_le_id IN (SELECT tole.legal_entity_id
1511: FROM gl_ledger_le_v tole
1512: WHERE tole.ledger_id = '||p_tp_ledger_id ||')';
1513:
1514: l_sla_unmatched_query := l_sla_unmatched_query || ' AND fia.to_le_id IN (SELECT tole.legal_entity_id
1515: FROM gl_ledger_le_v tole

Line 1515: FROM gl_ledger_le_v tole

1511: FROM gl_ledger_le_v tole
1512: WHERE tole.ledger_id = '||p_tp_ledger_id ||')';
1513:
1514: l_sla_unmatched_query := l_sla_unmatched_query || ' AND fia.to_le_id IN (SELECT tole.legal_entity_id
1515: FROM gl_ledger_le_v tole
1516: WHERE tole.ledger_id = '||p_tp_ledger_id ||')';
1517: END IF;
1518:
1519: IF P_TP_LEGAL_ENTITY_ID IS NOT NULL -- User input parameter

Line 1660: FROM gl_ledger_le_v tole

1656: l_get_account_query_rev := l_get_account_query_rev || ' AND fia2.ledger_id = '||p_trans_ledger_id;
1657:
1658:
1659: l_sum_unmatched_query_rev := l_sum_unmatched_query_rev || ' AND SRC_TRAD_LE_ID IN (SELECT tole.legal_entity_id
1660: FROM gl_ledger_le_v tole
1661: WHERE tole.ledger_id = '||p_trans_ledger_id ||')';
1662:
1663: l_gl_unmatched_query_rev := l_gl_unmatched_query_rev || ' AND fia.to_le_id IN (SELECT tole.legal_entity_id
1664: FROM gl_ledger_le_v tole

Line 1664: FROM gl_ledger_le_v tole

1660: FROM gl_ledger_le_v tole
1661: WHERE tole.ledger_id = '||p_trans_ledger_id ||')';
1662:
1663: l_gl_unmatched_query_rev := l_gl_unmatched_query_rev || ' AND fia.to_le_id IN (SELECT tole.legal_entity_id
1664: FROM gl_ledger_le_v tole
1665: WHERE tole.ledger_id = '||p_trans_ledger_id ||')';
1666:
1667: l_sla_unmatched_query_rev := l_sla_unmatched_query_rev || ' AND fia.to_le_id IN (SELECT tole.legal_entity_id
1668: FROM gl_ledger_le_v tole

Line 1668: FROM gl_ledger_le_v tole

1664: FROM gl_ledger_le_v tole
1665: WHERE tole.ledger_id = '||p_trans_ledger_id ||')';
1666:
1667: l_sla_unmatched_query_rev := l_sla_unmatched_query_rev || ' AND fia.to_le_id IN (SELECT tole.legal_entity_id
1668: FROM gl_ledger_le_v tole
1669: WHERE tole.ledger_id = '||p_trans_ledger_id ||')';
1670:
1671: END IF;
1672:

Line 2214: ,gl_ledger_le_v glv

2210: ,gl_import_references gir
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'

Line 2263: ,gl_ledger_le_v glv

2259: ,gl_import_references gir
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'

Line 2315: ,gl_ledger_le_v glv

2311: ,gl_import_references gir
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'

Line 2363: ,gl_ledger_le_v glv

2359: ,gl_import_references gir
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'