[Home] [Help]
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
776: AND txl.sty_id = sty.id -- May be we dont need outer join here
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
892: ,okl_rep_products_gt pdt_gt
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
1035: ,gl_je_lines gl
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
1398: ,okl_rep_products_gt pdt_gt
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
1522: -- OLM Reconciliation Report Entities
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
1673: -- GL Tables: Import Reference, GL Header and Lines
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
2028: ,okl_rep_products_gt pdt_gt
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
2156: WHERE -- OKL - AR Adjustment Application Predicates
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
2306: -- GL Tables: Import Reference, GL Header and Lines
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
2663: ,okl_rep_products_gt pdt_gt
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
2797: -- OLM Reconciliation Report Entities
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
2958: -- GL Tables: Import Reference, GL Header and Lines
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
3826: WHERE
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
4018: ,okl_trx_contracts_all trx
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
4237: ,ra_customer_trx_all rct
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
4462: -- OLM Tables
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
4683: ,ap_invoices_all inv
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
4978: WHERE
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
7211: ,okl_trx_contracts_all trx