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_GL_JE_B_C dependencies on GL_PERIODS

Line 1416: FROM gl_periods p, gl_ledgers_public_v s

1412: per2.start_date), --jeh.posted_date), -- for encumbrances
1413: null) -- for Commercial
1414: FROM (
1415: SELECT p.period_name, s.ledger_id
1416: FROM gl_periods p, gl_ledgers_public_v s
1417: WHERE p.start_date <= NVL(P_End_Date, start_date)
1418: AND p.end_date >= P_Start_Date
1419: AND p.period_set_name = s.period_set_name) per,
1420: (SELECT DISTINCT

Line 1433: gl_periods per2,

1429: AND fslg.usage_code = g_usage_code) fset,
1430: gl_je_headers jeh,
1431: fii_encum_type_mappings etype,
1432: fii_gl_processed_header_ids fgph,
1433: gl_periods per2,
1434: gl_ledgers_public_v s2
1435: WHERE jeh.ledger_id = fset.ledger_id
1436: AND jeh.encumbrance_type_id = etype.encumbrance_type_id (+)
1437: AND (jeh.je_source = fset.je_source_name OR fset.je_source_name = '-1')

Line 1988: FROM gl_periods p, gl_ledgers_public_v s

1984: ) jeb,
1985: financials_system_params_all org,
1986: (
1987: SELECT p.period_name, s.ledger_id
1988: FROM gl_periods p, gl_ledgers_public_v s
1989: WHERE p.start_date <= l_end_date
1990: AND p.end_date >= l_start_date
1991: AND p.period_set_name = s.period_set_name) per,
1992: (SELECT DISTINCT

Line 2037: gl_periods p,

2033: jeh.actual_flag, --Added for PSI
2034: decode(g_industry, 'G', NVL(etype.encumbrance_type, 'OTHERS'),
2035: 'C', NULL) encumbrance_type
2036: FROM gl_ledgers_public_v s,
2037: gl_periods p,
2038: gl_periods p2,
2039: gl_je_headers jeh,
2040: fii_encum_type_mappings etype,
2041: (SELECT /*+ no_merge */ DISTINCT

Line 2038: gl_periods p2,

2034: decode(g_industry, 'G', NVL(etype.encumbrance_type, 'OTHERS'),
2035: 'C', NULL) encumbrance_type
2036: FROM gl_ledgers_public_v s,
2037: gl_periods p,
2038: gl_periods p2,
2039: gl_je_headers jeh,
2040: fii_encum_type_mappings etype,
2041: (SELECT /*+ no_merge */ DISTINCT
2042: slga.ledger_id,

Line 2986: ' gl_periods per, '||

2982: ' other_amount_b, '||
2983: ' per.year_start_date '||
2984: 'FROM gl_balances b, '||
2985: ' gl_ledgers_public_v sob, '||
2986: ' gl_periods per, '||
2987: ' (SELECT /*+ full(slga) */ DISTINCT slga.ledger_id '||
2988: ' FROM fii_slg_assignments slga, '||
2989: ' fii_source_ledger_groups fslg '||
2990: ' WHERE slga.source_ledger_group_id =fslg.source_ledger_group_id '||