[Home] [Help]
692: AND ledger.ledger_id = trx.set_of_books_id
693: --End of Query Segment to fetch the UnAccounted Transactions
694: UNION ALL
695: -- Query Segment to fetch the UnAccounted Transactions
696: -- from OLM only. Imp Predicates: XLA_EVENTS.event_status_code in ( 'I', 'U' )
697: SELECT 'TRX_UNACCOUNTED' trx_detail_type_code
698: ,trx.trx_number trx_number
699: ,try.name trx_type_name
700: ,xvl.name trx_event_name
767: ,hr_operating_units ou
768: ,xle_entity_profiles le
769: ,gl_ledgers_v ledger
770: -- XLA Entities
771: ,xla_events xe
772: ,xla_event_types_vl xvl
773: WHERE trx.id = txl.tcn_id
774: AND trx.try_id = try.id
775: AND try.accounting_event_class_code IS NOT NULL
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
889: -- OLM Reconciliation Report Definitions Table
890: ,okl_reports_b rep
891: ,okl_report_trx_params rtryp
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
1032: -- GL Tables: Import Reference, GL Header and Lines
1033: ,gl_import_references gi
1034: ,gl_je_headers gh
1389: ,ra_customer_trx_lines_all rcl
1390: ,ra_customer_trx_all rct
1391: ,ra_cust_trx_line_gl_dist_all rad
1392: -- XLA Tables
1393: ,xla_events xe
1394: ,xla_event_types_vl xvl
1395: -- OLM Reconciliation Report Entities
1396: ,okl_reports_b rep
1397: ,okl_report_trx_params rtryp
1513: ,ra_customer_trx_lines_all rcl
1514: ,ra_customer_trx_all rct
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
1664: ,ra_customer_trx_lines_all rcl
1665: ,ra_customer_trx_all rct
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
2019: ,okl_strm_type_v sty
2020: -- AR Tables
2021: ,ar_adjustments_all radj
2022: -- XLA Tables
2023: ,xla_events xe
2024: ,xla_event_types_vl xvl
2025: -- OLM Reconciliation Report Entities
2026: ,okl_reports_b rep
2027: ,okl_report_trx_params rtryp
2147: -- To fetch Names
2148: ,hr_operating_units ou
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
2297: -- To fetch Names
2298: ,hr_operating_units ou
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
2654: ,ap_invoices_all inv
2655: ,ap_invoice_lines_all lin
2656: ,ap_invoice_distributions_all invdist
2657: -- XLA Tables
2658: ,xla_events xe
2659: ,xla_event_types_vl xvl
2660: -- OLM Reconciliation Report Entities
2661: ,okl_reports_b rep
2662: ,okl_report_trx_params rtryp
2788: ,ap_invoices_all inv
2789: ,ap_invoice_lines_all lin
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
2840: AND lin.invoice_id = inv.invoice_id
2841: -- AP to XLA Relations
2842: AND invdist.accounting_event_id = xe.event_id
2843: AND xe.application_id = 200 -- Payables
2844: AND xe.event_status_code = 'P' -- Pick Only processed XLA Events
2845: AND xe.application_id = xvl.application_id
2846: AND xvl.event_type_code = xe.event_type_code
2847: AND xd.event_id = xe.event_id
2848: AND xd.application_id = 200 -- Payables Application
2949: ,ap_invoices_all inv
2950: ,ap_invoice_lines_all lin
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
3005: AND lin.invoice_id = inv.invoice_id
3006: -- AP to XLA Relations
3007: AND invdist.accounting_event_id = xe.event_id
3008: AND xe.application_id = 200 -- Payables
3009: AND xe.event_status_code = 'P' -- Pick Only processed XLA Events
3010: AND xe.application_id = xvl.application_id
3011: AND xvl.event_type_code = xe.event_type_code
3012: AND xd.event_id = xe.event_id
3013: AND xd.application_id = 200 -- Payables Application
3817: ,okl_code_cmbns_gt cc
3818: -- SLA Entities
3819: ,xla_ae_lines xl
3820: ,xla_ae_headers xh
3821: ,xla_events xe
3822: ,xla_event_types_vl xvl
3823: ,xla_transaction_entities xte
3824: ,gl_ledgers ledger
3825: ,fnd_application_vl app
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
4017: ,okl_txl_cntrct_lns_all txl
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
4236: ,ra_customer_trx_lines_all rcl
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
4461: ,ar_adjustments_all radj
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
4682: ,ap_invoice_lines_all lin
4969: ,okl_code_cmbns_gt cc
4970: -- SLA Entities
4971: ,xla_ae_lines xl
4972: ,xla_ae_headers xh
4973: ,xla_events xe
4974: ,xla_event_types_vl xvl
4975: ,xla_transaction_entities xte
4976: ,gl_ledgers ledger
4977: ,fnd_application_vl app
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
7210: ,okl_txl_cntrct_lns_all txl