Field Name Level Values User Item Type Master FINISHED GOOD Item Status Org Active Inventory Item Master Yes Stockable Org Yes Transactable Org Yes Reservable Org Reservable Cycle Count Enabled [...]

  The Transactable Flag for an Item can be enabled only if the Item has Stockable Flag Enabled.

  The Returnable Flag should be Enabled, If the Item is returnable after successfully completion of order.

This query is to analyse the type of items that a customer is buying in specific period through out his orders. In the below example we have taken only the drop shipment or direct import orders [...]

This is a simple SQL Query used to show how the pivot option is used. Here in this example the columns JAN, FEB and MAR would be having single quotes and the other columns wont be having single [...]

select distinct aia.invoice_id, aia.Voucher_Number, d.file_name, d.url from fnd_attached_documents fad, ap_invoices_all aia, fnd_documents d where 1=1 and aia.invoice_id = fad.pk1_value and [...]

This is the table where all the netting agreement would be storing.   Script: select agreement_name, agreement_id from apps.fun_net_agreements_all;

This API is used to check the Accounting status of AP invoices.   Script: DECODE(apps.AP_INVOICES_PKG.GET_POSTING_STATUS( aia.invoice_id ), ‘P’, ‘Partial’, [...]

This Query is used to extract all the TAX Type that are available in the system, Especially used when Migrating the data and reporting purpose.   Script: SELECT ‘GST’ “Tax [...]

This Query is useful to fetch the vendor details that are having certificates for lower Tax Deduction rates or Exceptional Tax Deduction case vendors.   Script: SELECT vendor_name, pan_no, [...]