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_PERIODS

Line 68: gl_periods glp1,

64: FROM fun_inter_accounts_v fia1,
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

Line 72: gl_periods glp2

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
74: AND fia1.ccid = glb1.code_combination_id
75: AND fia1.type = ''R''
76: AND fia1.ledger_id = gl1.ledger_id

Line 267: ,gl_periods glp

263: ,gl_import_references gir
264: ,gl_je_lines gjl
265: ,gl_je_headers gjh
266: ,gl_je_batches gjb
267: ,gl_periods glp
268: ,xla_subledgers xsrc
269: ,gl_ledgers gl
270: , ($get_accounts_query$) fun_act
271: WHERE aeh.accounting_entry_status_code = ''F''

Line 421: ,gl_periods glp

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''
425: AND aeh.gl_transfer_status_code = ''Y''

Line 506: ,gl_periods glp

502: ,gl_je_sources_tl gjst
503: ,gl_je_lines gjl
504: ,gl_je_headers gjh
505: ,gl_je_batches gjb
506: ,gl_periods glp
507: , ($get_accounts_query$) fun_act
508: WHERE gjh.je_header_id = gjl.je_header_id
509: AND gjb.je_batch_id = gjh.je_batch_id
510: AND gjb.status = ''P''

Line 567: ,gl_periods glp

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''
571: AND gjct.je_category_name = gjh.je_category

Line 618: ,gl_periods glp

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
622: ,xla_event_types_b xet

Line 726: ,gl_periods glp

722: ,gl_daily_conversion_types gdct
723: ,gl_je_lines gjl
724: ,gl_je_headers gjh
725: ,gl_je_batches gjb
726: ,gl_periods glp
727: , ($get_accounts_query$) fun_act
728: WHERE gjh.je_header_id = gjl.je_header_id
729: AND gjb.je_batch_id = gjh.je_batch_id
730: AND gjb.status = ''P''

Line 820: ,gl_periods glp

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''
824: AND fdu.user_id = gjb.created_by

Line 1321: FROM gl_periods glp,

1317: p_period_name VARCHAR2)
1318: IS
1319: SELECT glp.start_date,
1320: glp.end_date
1321: FROM gl_periods glp,
1322: gl_ledgers gl
1323: WHERE glp.period_set_name = gl.period_set_name
1324: AND glp.period_type = gl.accounted_period_type
1325: AND glp.period_name = p_period_name

Line 2180: FROM gl_periods glp,

2176: else
2177: -- get the end date of l_trans_gl_period for l_trans_ledger_id
2178: SELECT glp.end_date, glp.adjustment_period_flag
2179: INTO l_trans_gl_prd_end_date, l_trans_adj_period_flag
2180: FROM gl_periods glp,
2181: gl_ledgers gl
2182: WHERE glp.period_set_name = gl.period_set_name
2183: AND glp.period_type = gl.accounted_period_type
2184: AND glp.period_name = l_trans_gl_period

Line 2189: FROM gl_periods glp,

2185: AND gl.ledger_id = l_trans_ledger_id;
2186:
2187: SELECT glp.period_name
2188: INTO l_trad_gl_period
2189: FROM gl_periods glp,
2190: gl_ledgers gl
2191: WHERE glp.period_set_name = gl.period_set_name
2192: AND glp.period_type = gl.accounted_period_type
2193: AND gl.ledger_id = l_trad_ledger_id

Line 2216: ,gl_periods glp

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'
2220: AND ael.ae_header_id = aeh.ae_header_id

Line 2265: ,gl_periods glp

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'
2269: AND ael.ae_header_id = aeh.ae_header_id

Line 2317: ,gl_periods glp

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'
2321: AND ael.ae_header_id = aeh.ae_header_id

Line 2365: ,gl_periods glp

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'
2369: AND ael.ae_header_id = aeh.ae_header_id