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 XLA_DISTRIBUTION_LINKS

Line 884: ,xla_distribution_links xd

880: ,okl_products pdt
881: ,okl_ae_tmpt_sets_all aes
882: ,okl_st_gen_tmpt_sets_all gts
883: -- SLA Entities
884: ,xla_distribution_links xd
885: ,xla_ae_headers xh
886: ,xla_ae_lines xl
887: ,xla_events xe
888: ,xla_event_types_vl xvl

Line 933: -- Important Predicate: XLA Distribution Links should not have the GL Import Link ID

929: AND xd.ae_header_id = xh.ae_header_id
930: AND xl.ae_header_id = xh.ae_header_id
931: AND xl.ledger_id = p_ledger_id
932: AND xd.ae_line_num = xl.ae_line_num --XD,XH,XL END
933: -- Important Predicate: XLA Distribution Links should not have the GL Import Link ID
934: AND xh.gl_transfer_status_code <> 'Y' -- Not Imported to GL Yet
935: -- Transaction should have occured in the Start and End date of the Context
936: AND trx.transaction_date >= p_start_date
937: AND trx.transaction_date <= p_end_date

Line 1027: ,xla_distribution_links xd

1023: ,okl_products pdt
1024: ,okl_ae_tmpt_sets_all aes
1025: ,okl_st_gen_tmpt_sets_all gts
1026: -- SLA Entities
1027: ,xla_distribution_links xd
1028: ,xla_ae_headers xh
1029: ,xla_ae_lines xl
1030: ,xla_events xe
1031: ,xla_event_types_vl xvl

Line 1519: ,xla_distribution_links xd

1515: ,ra_cust_trx_line_gl_dist_all rad
1516: -- XLA Tables
1517: ,xla_events xe
1518: ,xla_event_types_vl xvl
1519: ,xla_distribution_links xd
1520: ,xla_ae_headers xh
1521: ,xla_ae_lines xl
1522: -- OLM Reconciliation Report Entities
1523: ,okl_reports_b rep

Line 1578: -- Important Predicate: XLA Distribution Links should not have the GL Import Link ID

1574: AND xd.ae_header_id = xh.ae_header_id
1575: AND xl.ae_header_id = xh.ae_header_id
1576: AND xl.ledger_id = p_ledger_id
1577: AND xd.ae_line_num = xl.ae_line_num --XD,XH,XL END
1578: -- Important Predicate: XLA Distribution Links should not have the GL Import Link ID
1579: AND xh.gl_transfer_status_code <> 'Y' -- Not Imported to GL Yet
1580: -- Restrict to only one Distribution Line based on the Transaction Activity Code Add/Substract
1581: -- If its Add Consider only Debit, else if its Substract consider Credit
1582: AND

Line 1670: ,xla_distribution_links xd

1666: ,ra_cust_trx_line_gl_dist_all rad
1667: -- XLA Tables
1668: ,xla_events xe
1669: ,xla_event_types_vl xvl
1670: ,xla_distribution_links xd
1671: ,xla_ae_headers xh
1672: ,xla_ae_lines xl
1673: -- GL Tables: Import Reference, GL Header and Lines
1674: ,gl_import_references gi

Line 1748: -- Important Predicate: XLA Distribution Links should have the GL Import Link ID

1744: DECODE(rtryp.add_substract_code,
1745: 'ADD', 'DEBIT_DIST', 'SUBTRACT', 'CREDIT_DIST' )
1746: )
1747: -- From SLA to GL Tables Link
1748: -- Important Predicate: XLA Distribution Links should have the GL Import Link ID
1749: AND gi.gl_sl_link_id = xl.gl_sl_link_id --GL TABLES JOIN START
1750: AND gl.ledger_id = xl.ledger_id
1751: AND gi.gl_sl_link_table = xl.gl_sl_link_table
1752: AND gi.je_header_id = gh.je_header_id

Line 2153: ,xla_distribution_links xd

2149: ,gl_ledgers_v ledger
2150: -- XLA Tables
2151: ,xla_events xe
2152: ,xla_event_types_vl xvl
2153: ,xla_distribution_links xd
2154: ,xla_ae_headers xh
2155: ,xla_ae_lines xl
2156: WHERE -- OKL - AR Adjustment Application Predicates
2157: adj.id = ajl.adj_id

Line 2202: -- Important Predicate: XLA Distribution Links should not have the GL Import Link ID

2198: AND xd.ae_header_id = xh.ae_header_id
2199: AND xl.ae_header_id = xh.ae_header_id
2200: AND xl.ledger_id = p_ledger_id
2201: AND xd.ae_line_num = xl.ae_line_num --XD,XH,XL END
2202: -- Important Predicate: XLA Distribution Links should not have the GL Import Link ID
2203: AND xh.gl_transfer_status_code <> 'Y' -- Not Imported to GL Yet
2204: -- Restrict to only one Distribution Line based on the Transaction Activity Code Add/Substract
2205: -- If its Add Consider only Debit, else if its Substract consider Credit
2206: AND

Line 2303: ,xla_distribution_links xd

2299: ,gl_ledgers_v ledger
2300: -- XLA Tables
2301: ,xla_events xe
2302: ,xla_event_types_vl xvl
2303: ,xla_distribution_links xd
2304: ,xla_ae_headers xh
2305: ,xla_ae_lines xl
2306: -- GL Tables: Import Reference, GL Header and Lines
2307: ,gl_import_references gi

Line 2370: -- Important Predicate: XLA Distribution Links should have the GL Import Link ID

2366: DECODE(rtryp.add_substract_code,
2367: 'ADD', 'DEBIT_DIST', 'SUBTRACT', 'CREDIT_DIST' )
2368: )
2369: -- From SLA to GL Tables Link
2370: -- Important Predicate: XLA Distribution Links should have the GL Import Link ID
2371: AND gi.gl_sl_link_id = xl.gl_sl_link_id --GL TABLES JOIN START
2372: AND gl.ledger_id = xl.ledger_id
2373: AND gi.gl_sl_link_table = xl.gl_sl_link_table
2374: AND gi.je_header_id = gh.je_header_id

Line 2794: ,xla_distribution_links xd

2790: ,ap_invoice_distributions_all invdist
2791: -- XLA Tables
2792: ,xla_events xe
2793: ,xla_event_types_vl xvl
2794: ,xla_distribution_links xd
2795: ,xla_ae_headers xh
2796: ,xla_ae_lines xl
2797: -- OLM Reconciliation Report Entities
2798: ,okl_reports_b rep

Line 2855: -- Important Predicate: XLA Distribution Links should not have the GL Import Link ID

2851: AND xd.ae_header_id = xh.ae_header_id
2852: AND xl.ae_header_id = xh.ae_header_id
2853: AND xl.ledger_id = p_ledger_id
2854: AND xd.ae_line_num = xl.ae_line_num --XD,XH,XL END
2855: -- Important Predicate: XLA Distribution Links should not have the GL Import Link ID
2856: AND xh.gl_transfer_status_code <> 'Y' -- Not Imported to GL Yet
2857: -- Restrict to only one Distribution Line based on the Transaction Activity Code Add/Substract
2858: -- If its Add Consider only Debit, else if its Substract consider Credit
2859: AND

Line 2955: ,xla_distribution_links xd

2951: ,ap_invoice_distributions_all invdist
2952: -- XLA Tables
2953: ,xla_events xe
2954: ,xla_event_types_vl xvl
2955: ,xla_distribution_links xd
2956: ,xla_ae_headers xh
2957: ,xla_ae_lines xl
2958: -- GL Tables: Import Reference, GL Header and Lines
2959: ,gl_import_references gi

Line 3033: -- Important Predicate: XLA Distribution Links should have the GL Import Link ID

3029: DECODE(rtryp.add_substract_code,
3030: 'ADD', 'DEBIT_DIST', 'SUBTRACT', 'CREDIT_DIST' )
3031: )
3032: -- From SLA to GL Tables Link
3033: -- Important Predicate: XLA Distribution Links should have the GL Import Link ID
3034: AND gi.gl_sl_link_id = xl.gl_sl_link_id
3035: AND gl.ledger_id = xl.ledger_id
3036: AND gi.gl_sl_link_table = xl.gl_sl_link_table
3037: AND gi.je_header_id = gh.je_header_id

Line 4012: ,xla_distribution_links xd

4008: ,okl_code_cmbns_gt cc
4009: -- SLA Entities
4010: ,xla_ae_lines xl
4011: ,xla_ae_headers xh
4012: ,xla_distribution_links xd
4013: ,xla_events xe
4014: ,xla_event_types_vl xvl
4015: -- OLM Entities
4016: ,okl_trns_acc_dstrs_all dist

Line 4231: ,xla_distribution_links xd

4227: ,okl_code_cmbns_gt cc
4228: -- SLA Entities
4229: ,xla_ae_lines xl
4230: ,xla_ae_headers xh
4231: ,xla_distribution_links xd
4232: ,xla_events xe
4233: ,xla_event_types_vl xvl
4234: -- AR Tables
4235: ,ra_cust_trx_line_gl_dist_all rad

Line 4456: ,xla_distribution_links xd

4452: ,okl_code_cmbns_gt cc
4453: -- SLA Entities
4454: ,xla_ae_lines xl
4455: ,xla_ae_headers xh
4456: ,xla_distribution_links xd
4457: ,xla_events xe
4458: ,xla_event_types_vl xvl
4459: -- AR Tables
4460: ,ar_distributions_all rdist

Line 4677: ,xla_distribution_links xd

4673: ,okl_code_cmbns_gt cc
4674: -- SLA Entities
4675: ,xla_ae_lines xl
4676: ,xla_ae_headers xh
4677: ,xla_distribution_links xd
4678: ,xla_events xe
4679: ,xla_event_types_vl xvl
4680: -- AP Tables
4681: ,ap_invoice_distributions_all invdist

Line 7205: ,xla_distribution_links xd

7201: ,okl_code_cmbns_gt cc
7202: -- SLA Entities
7203: ,xla_ae_lines xl
7204: ,xla_ae_headers xh
7205: ,xla_distribution_links xd
7206: ,xla_events xe
7207: ,xla_event_types_vl xvl
7208: -- OLM Entities
7209: ,okl_trns_acc_dstrs_all dist