Introduction: The below query fetches the details of an Invoice along with the HSN Code of a respective item present in an Invoice. GST details can also be fetched. SELECT…
Read MoreIntroduction This Post is Described about the Delivery Challan with GST Details in ebs r12 Query retrieves data of those inventory items which are used for promotional purposes or…
Read MoreThe below query fetches the details of a tax invocie where in Reverse charge mechanism(RCM) is applied in order to claim the extra tax paid by an organization along with…
Read MoreIntroduction The below query fetches the data of purchase order wherein those items present in purchase order needs to be returned to Supplier because of some damage caused to goods…
Read MoreIntroduction This Post Is Described about the RMA Receipt Query-GST In oracle apps R12. select orgid,ORGCODE, ORGNAME, account_number, party_name,city, LINE_NUMBER, trx_number,trx_date, location, src_number,src_date,rma_gross,TAX_RATE_PERCENTAGE, interface_header_attribute2,reason_code,CGST,SGST,IGST,VAT,CST,(nvl(rma_gross,0) + nvl(CGST,0) + nvl(SGST,0) +…
Read MoreIntroduction This Post illustrates the steps required to get the General ledger analysis for PA Expenditure & Event in oracle Apps Script for GL Account analysis for PA Expenditure &…
Read MoreDescription: A full index scan is where Oracle reads the data from the index, and the index is in the order required by the query. A fast full index scan is similar to a full index scan. This type of scan happens when…
Read MoreDescription: This password is required for opening the document. It enables users to open the document only. This property is enabled only when “Enable PDF Security” is set to “true.”…
Read MoreDescription Invoices and Credit Memos in Oracle AR: Invoice: A document that will convey how much the customer has to pay for the goods and services he has bought and…
Read MoreDescription: A bursting definition is a component of the data model. After you have defined the data sets for the data model, you can set up one or more bursting…
Read More