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.OKL_REPORT_GENERATOR_PVT dependencies on OKL_CODE_CMBNS_GT

Line 7: -- Description : Populates the okl_code_cmbns_gt table

3:
4: -- Start of comments
5: --
6: -- Function Name : populate_code_combinations
7: -- Description : Populates the okl_code_cmbns_gt table
8: --
9: -- Business Rules : Called from prepare_gross_rec_report before any other
10: --report call /*important */
11: -- Parameters :

Line 131: -- Description : Populates the okl_code_cmbns_gt table

127:
128: -- Start of comments
129: --
130: -- Function Name : populate_code_combinations
131: -- Description : Populates the okl_code_cmbns_gt table
132: --
133: -- Business Rules : Called from prepare_gross_rec_report before any other
134: --report call /*important */
135: -- Parameters :

Line 216: 'INSERT INTO okl_code_cmbns_gt ('

212: 'Report Id=' || p_report_id );
213:
214: -- Prepare the Query String
215: l_query_string :=
216: 'INSERT INTO okl_code_cmbns_gt ('
217: ||' ccid'
218: ||' ,account_number'
219: ||')'
220: ||' SELECT cc.code_combination_id'

Line 268: -- Description : Populates the okl_code_cmbns_gt table

264:
265: -- Start of comments
266: --
267: -- Function Name : populate_code_combinations
268: -- Description : Populates the okl_code_cmbns_gt table
269: --
270: -- Business Rules : Called from prepare_gross_rec_report before any other
271: --report call /*important */
272: -- Parameters :

Line 435: -- Description : Populates the okl_code_cmbns_gt table

431:
432: -- Start of comments
433: --
434: -- Function Name : populate_code_combinations
435: -- Description : Populates the okl_code_cmbns_gt table
436: --
437: -- Business Rules : Called from prepare_gross_rec_report before any other
438: --report call /*important */
439: -- Parameters :

Line 3066: -- check whether the Code Combination does not exists in the okl_code_cmbns_gt

3062: -- Update the entries which are not posted into the specified Accounts
3063: -- Logic:
3064: -- Step 1:
3065: -- For each record with detail type as TRX_POSTED in okl_g_reports_gt
3066: -- check whether the Code Combination does not exists in the okl_code_cmbns_gt
3067: -- If it doesnot exist, update the detail type from TRX_POSTED to TRX_POST_NON_SPEC_ACCOUNTS
3068: UPDATE okl_g_reports_gt
3069: SET value1_text -- trx_detail_type_code
3070: = 'TRX_POST_NON_SPEC_ACCOUNTS'

Line 3079: FROM okl_code_cmbns_gt

3075: )
3076: NOT IN
3077: (
3078: SELECT ccid
3079: FROM okl_code_cmbns_gt
3080: );
3081: -- Step 2:
3082: -- And then, take rest of the records and,
3083: -- For each record with detail type as TRX_POSTED now in okl_g_reports_gt

Line 3656: ,okl_code_cmbns_gt cc

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
3658: ,fnd_application_vl app
3659: WHERE
3660: -- Restrict the Code Combinations to the one setup on the Report

Line 3817: ,okl_code_cmbns_gt cc

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
3818: -- SLA Entities
3819: ,xla_ae_lines xl
3820: ,xla_ae_headers xh
3821: ,xla_events xe

Line 4008: ,okl_code_cmbns_gt cc

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
4009: -- SLA Entities
4010: ,xla_ae_lines xl
4011: ,xla_ae_headers xh
4012: ,xla_distribution_links xd

Line 4227: ,okl_code_cmbns_gt cc

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
4228: -- SLA Entities
4229: ,xla_ae_lines xl
4230: ,xla_ae_headers xh
4231: ,xla_distribution_links xd

Line 4452: ,okl_code_cmbns_gt cc

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
4453: -- SLA Entities
4454: ,xla_ae_lines xl
4455: ,xla_ae_headers xh
4456: ,xla_distribution_links xd

Line 4673: ,okl_code_cmbns_gt cc

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
4674: -- SLA Entities
4675: ,xla_ae_lines xl
4676: ,xla_ae_headers xh
4677: ,xla_distribution_links xd

Line 4969: ,okl_code_cmbns_gt cc

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
4970: -- SLA Entities
4971: ,xla_ae_lines xl
4972: ,xla_ae_headers xh
4973: ,xla_events xe

Line 5156: ,okl_code_cmbns_gt cc_gt

5152: ,( begin_balance_dr_beq
5153: - begin_balance_cr_beq ) opening_bal_led_curr
5154: FROM gl_balances bal
5155: ,gl_ledgers led
5156: ,okl_code_cmbns_gt cc_gt
5157: WHERE led.ledger_id = p_ledger_id
5158: AND bal.ledger_id = led.ledger_id
5159: -- opening Balance as on Period Start
5160: AND bal.translated_flag IS NULL

Line 5188: ,okl_code_cmbns_gt cc_gt

5184: ,( begin_balance_dr
5185: - begin_balance_cr ) opening_bal_led_curr
5186: FROM gl_balances bal
5187: ,gl_ledgers led
5188: ,okl_code_cmbns_gt cc_gt
5189: WHERE led.ledger_id = p_ledger_id
5190: AND bal.ledger_id = led.ledger_id
5191: -- opening Balance as on Period Start
5192: AND bal.translated_flag IS NULL

Line 5270: from okl_code_cmbns_gt) cgt

5266: ,cgt.account_number --value13_text -- Stores the Segment Number
5267: ,0 --value1_num
5268: ,0 --value2_num
5269: FROM (select distinct account_number
5270: from okl_code_cmbns_gt) cgt
5271: WHERE cgt.account_number not in (select value13_text
5272: from okl_g_reports_gt
5273: where value1_text = 'GL_OPENING_BALANCE'
5274: );

Line 5327: ,okl_code_cmbns_gt cc_gt

5323: ,period_net_dr_beq -
5324: period_net_cr_beq period_activity_led_curr
5325: FROM gl_balances bal
5326: ,gl_ledgers led
5327: ,okl_code_cmbns_gt cc_gt
5328: ,gl_period_statuses gps
5329: WHERE led.ledger_id = p_ledger_id
5330: AND bal.ledger_id = led.ledger_id
5331: AND gps.application_id = 101

Line 5375: ,okl_code_cmbns_gt cc_gt

5371: ,period_net_dr -
5372: period_net_cr period_activity_led_curr
5373: FROM gl_balances bal
5374: ,gl_ledgers led
5375: ,okl_code_cmbns_gt cc_gt
5376: ,gl_period_statuses gps
5377: WHERE led.ledger_id = p_ledger_id
5378: AND gps.application_id = 101
5379: and gps.ledger_id = led.ledger_id

Line 5474: from okl_code_cmbns_gt) cgt

5470: -- Number Formatted Columns
5471: ,0 --value1_num
5472: ,0 --value2_num
5473: FROM (select distinct account_number
5474: from okl_code_cmbns_gt) cgt
5475: WHERE cgt.account_number not in (select value13_text
5476: from okl_g_reports_gt
5477: where value1_text = 'GL_PERIOD_ACTIVITY'
5478: );

Line 5548: ,okl_code_cmbns_gt cc_gt

5544: )
5545: ) closing_bal_led_curr
5546: FROM gl_balances bal
5547: ,gl_ledgers led
5548: ,okl_code_cmbns_gt cc_gt
5549: WHERE led.ledger_id = p_ledger_id
5550: AND bal.ledger_id = led.ledger_id
5551: -- Closing Balance as on Period End
5552: AND bal.period_name = p_period_to

Line 5587: ,okl_code_cmbns_gt cc_gt

5583: )
5584: ) closing_bal_led_curr
5585: FROM gl_balances bal
5586: ,gl_ledgers led
5587: ,okl_code_cmbns_gt cc_gt
5588: WHERE led.ledger_id = p_ledger_id
5589: AND bal.ledger_id = led.ledger_id
5590: -- Closing Balance as on Period End
5591: AND bal.period_name = p_period_to

Line 5670: from okl_code_cmbns_gt) cgt

5666: -- Number Formatted Columns
5667: ,0 --value1_num
5668: ,0 --value2_num
5669: FROM (select distinct account_number
5670: from okl_code_cmbns_gt) cgt
5671: WHERE cgt.account_number not in (select value13_text
5672: from okl_g_reports_gt
5673: where value1_text = 'GL_CLOSING_BALANCE'
5674: );

Line 7201: ,okl_code_cmbns_gt cc

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
7202: -- SLA Entities
7203: ,xla_ae_lines xl
7204: ,xla_ae_headers xh
7205: ,xla_distribution_links xd