[Home] [Help]
1030: ,xla_events xe
1031: ,xla_event_types_vl xvl
1032: -- GL Tables: Import Reference, GL Header and Lines
1033: ,gl_import_references gi
1034: ,gl_je_headers gh
1035: ,gl_je_lines gl
1036: -- OKL Report Definition Tables
1037: ,okl_reports_b rep
1038: ,okl_report_trx_params rtryp
1085: AND gi.je_header_id = gh.je_header_id
1086: AND gh.je_header_id = gl.je_header_id
1087: AND gi.je_line_num = gl.je_line_num
1088: AND gh.je_source = 'Lease'
1089: -- Important Predicate: gl_je_headers.status can be either Posted
1090: -- There can be even Unposted Entries
1091: AND gh.status IN ( 'U', 'P' ) -- Unposted or Posted Entries
1092: -- Transaction should have occured in the Start and End date of the Context
1093: AND trx.transaction_date >= p_start_date
1671: ,xla_ae_headers xh
1672: ,xla_ae_lines xl
1673: -- GL Tables: Import Reference, GL Header and Lines
1674: ,gl_import_references gi
1675: ,gl_je_headers gh
1676: ,gl_je_lines gl
1677: ,gl_code_combinations_kfv glcc
1678: -- OLM Reconciliation Report Entities
1679: ,okl_reports_b rep
1753: AND gh.je_header_id = gl.je_header_id
1754: AND gi.je_line_num = gl.je_line_num
1755: -- AND gl.code_combination_id = cc.ccid
1756: AND gh.je_source = 'Receivables'
1757: -- Important Predicate: gl_je_headers.status can be either Posted
1758: -- There can be even Unposted Entries
1759: AND gh.status IN ( 'U', 'P' ) -- Unposted or Posted Entries
1760: );
1761: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
2304: ,xla_ae_headers xh
2305: ,xla_ae_lines xl
2306: -- GL Tables: Import Reference, GL Header and Lines
2307: ,gl_import_references gi
2308: ,gl_je_headers gh
2309: ,gl_je_lines gl
2310: ,gl_code_combinations_kfv glcc
2311: WHERE -- OKL - AR Adjustment Application Predicates
2312: adj.id = ajl.adj_id
2375: AND gh.je_header_id = gl.je_header_id
2376: AND gi.je_line_num = gl.je_line_num
2377: -- AND gl.code_combination_id = cc.ccid
2378: AND gh.je_source = 'Receivables'
2379: -- Important Predicate: gl_je_headers.status can be either Posted
2380: -- There can be even Unposted Entries
2381: AND gh.status IN ( 'U', 'P' ) -- Unposted or Posted Entries
2382: );
2383: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
2956: ,xla_ae_headers xh
2957: ,xla_ae_lines xl
2958: -- GL Tables: Import Reference, GL Header and Lines
2959: ,gl_import_references gi
2960: ,gl_je_headers gh
2961: ,gl_je_lines gl
2962: -- OLM Reconciliation Report Entities
2963: ,okl_reports_b rep
2964: ,okl_report_trx_params rtryp
3038: AND gh.je_header_id = gl.je_header_id
3039: AND gi.je_line_num = gl.je_line_num
3040: -- AND gl.code_combination_id = cc.ccid
3041: AND gh.je_source = 'Payables'
3042: -- Important Predicate: gl_je_headers.status can be either Posted Or Unposted
3043: AND gh.status IN ( 'U', 'P' ) -- Unposted or Posted Entries
3044: );
3045: put_in_log(l_debug_enabled,is_debug_procedure_on,is_debug_statement_on,l_module, 'S',
3046: 'After Inserting the Payables Invoice Transactions Data in GT Table End Time:'
3649: ,NULL trx_try_id
3650: ,NULL trx_dist_id
3651: FROM -- GL Tables: Import Reference, GL Header and Lines
3652: gl_je_lines gl
3653: ,gl_je_headers gh
3654: ,gl_code_combinations_kfv glcc
3655: -- Code Combination GT Table
3656: ,okl_code_cmbns_gt cc
3657: ,gl_ledgers ledger
3809: ,NULL trx_try_id
3810: ,NULL trx_dist_id
3811: FROM -- GL Tables: Import Reference, GL Header and Lines
3812: gl_je_lines gl
3813: ,gl_je_headers gh
3814: ,gl_code_combinations_kfv glcc
3815: ,gl_import_references gi
3816: -- Code Combination GT Table
3817: ,okl_code_cmbns_gt cc
4000: ,trx.try_id trx_try_id
4001: ,dist.id trx_dist_id
4002: FROM -- GL Tables: Import Reference, GL Header and Lines
4003: gl_je_lines gl
4004: ,gl_je_headers gh
4005: ,gl_code_combinations_kfv glcc
4006: ,gl_import_references gi
4007: -- Code Combination GT Table
4008: ,okl_code_cmbns_gt cc
4219: ,tai.try_id trx_try_id
4220: ,NULL trx_dist_id
4221: FROM -- GL Tables: Import Reference, GL Header and Lines
4222: gl_je_lines gl
4223: ,gl_je_headers gh
4224: ,gl_code_combinations_kfv glcc
4225: ,gl_import_references gi
4226: -- Code Combination GT Table
4227: ,okl_code_cmbns_gt cc
4444: ,adj.try_id trx_try_id
4445: ,NULL trx_dist_id
4446: FROM -- GL Tables: Import Reference, GL Header and Lines
4447: gl_je_lines gl
4448: ,gl_je_headers gh
4449: ,gl_code_combinations_kfv glcc
4450: ,gl_import_references gi
4451: -- Code Combination GT Table
4452: ,okl_code_cmbns_gt cc
4665: ,tap.try_id trx_try_id
4666: ,invdist.invoice_distribution_id trx_dist_id
4667: FROM -- GL Tables: Import Reference, GL Header and Lines
4668: gl_je_lines gl
4669: ,gl_je_headers gh
4670: ,gl_code_combinations_kfv glcc
4671: ,gl_import_references gi
4672: -- Code Combination GT Table
4673: ,okl_code_cmbns_gt cc
4961: ,NULL trx_try_id
4962: ,NULL trx_dist_id
4963: FROM -- GL Tables: Import Reference, GL Header and Lines
4964: gl_je_lines gl
4965: ,gl_je_headers gh
4966: ,gl_code_combinations_kfv glcc
4967: ,gl_import_references gi
4968: -- Code Combination GT Table
4969: ,okl_code_cmbns_gt cc
7193: ,trx.try_id trx_try_id
7194: ,dist.id trx_dist_id
7195: FROM -- GL Tables: Import Reference, GL Header and Lines
7196: gl_je_lines gl
7197: ,gl_je_headers gh
7198: ,gl_code_combinations_kfv glcc
7199: ,gl_import_references gi
7200: -- Code Combination GT Table
7201: ,okl_code_cmbns_gt cc