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.

[Home] [Help]

APPS.FUN_RECON_RPT_PKG dependencies on GL_PERIODS

Line 63: gl_periods glp1,

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
67: WHERE fia1.ledger_id = glb1.ledger_id

Line 66: gl_periods glp2

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''
70: AND fia1.ledger_id = gl1.ledger_id

Line 258: ,gl_periods glp

254: ,gl_import_references gir
255: ,gl_je_lines gjl
256: ,gl_je_headers gjh
257: ,gl_je_batches gjb
258: ,gl_periods glp
259: ,xla_subledgers xsrc
260: , ($get_accounts_query$) fun_act
261: WHERE aeh.accounting_entry_status_code = ''F''
262: AND aeh.gl_transfer_status_code = ''Y''

Line 403: ,gl_periods glp

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''
406: AND aeh.gl_transfer_status_code = ''Y''
407: AND ael.ae_header_id = aeh.ae_header_id

Line 479: ,gl_periods glp

475: ,gl_je_sources_tl gjst
476: ,gl_je_lines gjl
477: ,gl_je_headers gjh
478: ,gl_je_batches gjb
479: ,gl_periods glp
480: , ($get_accounts_query$) fun_act
481: WHERE gjh.je_header_id = gjl.je_header_id
482: AND gjb.je_batch_id = gjh.je_batch_id
483: AND gjb.status = ''P''

Line 540: ,gl_periods glp

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
543: AND gjb.status = ''P''
544: AND gjct.je_category_name = gjh.je_category

Line 591: ,gl_periods glp

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
594: ,xla_events xle
595: ,xla_event_types_b xet

Line 699: ,gl_periods glp

695: ,gl_daily_conversion_types gdct
696: ,gl_je_lines gjl
697: ,gl_je_headers gjh
698: ,gl_je_batches gjb
699: ,gl_periods glp
700: , ($get_accounts_query$) fun_act
701: WHERE gjh.je_header_id = gjl.je_header_id
702: AND gjb.je_batch_id = gjh.je_batch_id
703: AND gjb.status = ''P''

Line 793: ,gl_periods glp

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
796: AND gjb.status = ''P''
797: AND fdu.user_id = gjb.created_by

Line 1295: FROM gl_periods glp,

1291: p_period_name VARCHAR2)
1292: IS
1293: SELECT glp.start_date,
1294: glp.end_date
1295: FROM gl_periods glp,
1296: gl_ledgers gl
1297: WHERE glp.period_set_name = gl.period_set_name
1298: AND glp.period_type = gl.accounted_period_type
1299: AND glp.period_name = p_period_name

Line 2074: FROM gl_periods glp,

2070: else
2071: -- get the end date of l_trans_gl_period for l_trans_ledger_id
2072: SELECT glp.end_date, glp.adjustment_period_flag
2073: INTO l_trans_gl_prd_end_date, l_trans_adj_period_flag
2074: FROM gl_periods glp,
2075: gl_ledgers gl
2076: WHERE glp.period_set_name = gl.period_set_name
2077: AND glp.period_type = gl.accounted_period_type
2078: AND glp.period_name = l_trans_gl_period

Line 2083: FROM gl_periods glp,

2079: AND gl.ledger_id = l_trans_ledger_id;
2080:
2081: SELECT glp.period_name
2082: INTO l_trad_gl_period
2083: FROM gl_periods glp,
2084: gl_ledgers gl
2085: WHERE glp.period_set_name = gl.period_set_name
2086: AND glp.period_type = gl.accounted_period_type
2087: AND gl.ledger_id = l_trad_ledger_id

Line 2110: ,gl_periods glp

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'
2113: AND aeh.gl_transfer_status_code = 'Y'
2114: AND ael.ae_header_id = aeh.ae_header_id

Line 2159: ,gl_periods glp

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'
2162: AND aeh.gl_transfer_status_code = 'Y'
2163: AND ael.ae_header_id = aeh.ae_header_id

Line 2211: ,gl_periods glp

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'
2214: AND aeh.gl_transfer_status_code = 'Y'
2215: AND ael.ae_header_id = aeh.ae_header_id

Line 2259: ,gl_periods glp

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'
2262: AND aeh.gl_transfer_status_code = 'Y'
2263: AND ael.ae_header_id = aeh.ae_header_id