Query to Link AP Invoices, GL and SLA Tables: R12 AP GL XLA
Description: We will discuss about xla tables in r12. We all know that accounting from sub-ledgers transfer to general ledger through the xla /SL module. So to fetch the data…
Read MoreQuery to Link AP Payments, GL and SLA Tables: R12 AP GL XLA
Description: All accounting performed before transfer to the GL. Accounting data generated and stored in “Accounting Events” tables before transfer to GL. Run “Create Accounting” to populate accounting events (SLA)…
Read MoreQuery to Link AP Invoices, Payments, GL and SLA Tables: R12 AP GL XLA
Description: In R12, AP does not store any accounting information. Reconciliation of the posted transactions is done using data in the Sub ledger Accounting (SLA) tables. SELECT /*+ Index(xdl XLA_DISTRIBUTION_LINKS_N3) */…
Read MoreQuery to Link Shipments, AP Invoice, GL and SLA Tables: R12 AP GL RCV XLA
Description: In R12, we have tables that holds link between any sub-ledger data to General ledger data. The below query gives you the important columns available in the XLA tables and GL…
Read MoreAP Invoice liability (Trial Balance) Query: R12 AP GL PO RCV XLA
Description: Account payable trial balance is used to verify payable liabilities that are mentioned in the general ledger. This helps the businesses while reconciling their bank statements. Trial balance includes subtotal of unpaid and partially paid invoices…
Read MoreProject Expenditure Extraction Query
Introduction This query fetches all the expenses incurred on a project,and also captures the debit and credit account transaction wise that will help in reconcilation of data with GL. …
Read MoreTable Partitioning
Description: Every data should be stored in the database because the world can’t run without storing the data’s in the database. Machinery world should save data in a database for future reference and process so that…
Read MoreQuery for Supplier details with banks
Introduction This Post is about to Supplier details with banks query in oracle r12. Query for Supplier details with banks. SELECT aps.vendor_name|| ‘ ~ ‘|| ass.vendor_site_code “Payee_Identifier” ,accts.ext_bank_account_id “Payee_Bank_Account_Identifier”…
Read MoreGST TAX Details For EBS R12
Introduction This post is about to GST TAX Details query in EBS R12 select decode(substr(h.tax_rate_code,1,4),’SGST’,nvl(h.unround_tax_amt_tax_curr,0)) SGST_AMT , decode(substr(h.tax_rate_code,1,4),’CGST’,nvl(h.unround_tax_amt_tax_curr,0)) CGST_AMT , decode(substr(h.tax_rate_code,1,4),’SGST’,nvl(h.tax_rate_percentage,0)) SGST_RATE, decode(substr(h.tax_rate_code,1,4),’CGST’,nvl(h.tax_rate_percentage,0)) CGST_RATE, h.first_party_primary_reg_num GST_NUM, h.third_party_primary_reg_num CUSOMER_GST_NUM, h.ledger_id LEDGER_ID , h.trx_number INVOICE_NUM,(SELECT jra.reporting_code FROM jai_reporting_associations jra,…
Read MoreQuery for AR Transactions Header with GST
Introduction This Post is about to AR Transactions Header with GST Query. SELECT DISTINCT rcta.trx_number, rcta.ct_reference, lep.legal_entity_id, lep.NAME legal_entity, rcta.trx_date invoice_date, –Bill to location details hp.party_name bill_cust_name, hcs1.LOCATION bill_to_loc, RTRIM (hrl.address_line_1, ‘,’) Billadd1, RTRIM (hrl.address_line_2, ‘,’) Billadd2, RTRIM (hrl.address_line_3, ‘,’) Billadd3, RTRIM (hrl.loc_information15, ‘,’) Billadd4,…
Read More