shilpisingh-oracle/SQL-Optimization

1[2  "GL_JE_LINES stores journal debit and credit amounts with JE_HEADER_ID and CODE_COMBINATION_ID",3  "GL_JE_HEADERS stores journal headers including PERIOD_NAME and LEDGER_ID",4  "GL_CODE_COMBINATIONS stores chart of accounts segments",5  "GL_BALANCES stores balances by account and period",6  "GL_PERIODS stores accounting periods",7 8  "AP_INVOICES_ALL stores supplier invoices",9  "AP_INVOICE_LINES_ALL stores invoice lines",10  "AP_INVOICE_DISTRIBUTIONS_ALL stores invoice accounting distributions",11  "AP_SUPPLIERS stores supplier master data",12  "AP_SUPPLIER_SITES_ALL stores supplier site details",13  "AP_INVOICE_PAYMENTS_ALL stores invoice payments",14 15  "RA_CUSTOMER_TRX_ALL stores customer invoices",16  "RA_CUSTOMER_TRX_LINES_ALL stores invoice line details",17  "AR_CASH_RECEIPTS_ALL stores customer payments",18  "AR_PAYMENT_SCHEDULES_ALL stores payment schedules",19  "AR_RECEIVABLE_APPLICATIONS_ALL stores receipt applications",20 21  "XLA_AE_HEADERS stores subledger accounting headers",22  "XLA_AE_LINES stores subledger accounting lines",23  "XLA_DISTRIBUTION_LINKS links transactions to accounting",24  "XLA_TRANSACTION_ENTITIES maps transactions",25 26  "CE_BANK_ACCOUNTS stores bank account details",27  "CE_STATEMENT_HEADERS stores bank statements",28  "CE_STATEMENT_LINES stores bank statement lines",29 30  "FA_ADDITIONS_B stores asset master records",31  "FA_BOOKS stores asset book details",32  "FA_DEPRN_SUMMARY stores depreciation summary",33  "FA_DEPRN_DETAIL stores depreciation details",34 35  "HZ_PARTIES stores party master data",36  "HZ_CUST_ACCOUNTS stores customer accounts",37  "HZ_CUST_ACCT_SITES_ALL stores customer sites",38  "HZ_LOCATIONS stores addresses",39 40  "PO_HEADERS_ALL stores purchase orders",41  "PO_LINES_ALL stores purchase order lines",42  "PO_DISTRIBUTIONS_ALL stores PO distributions",43  "PO_SUPPLIERS maps to suppliers",44 45  "EXM_EXPENSE_REPORTS stores employee expense reports",46  "EXM_EXPENSE_LINES stores expense line items"47]