SELECT aps.vendor_name|| ‘ ~ ‘|| ass.vendor_site_code “Payee_Identifier” ,accts.ext_bank_account_id “Payee_Bank_Account_Identifier” ,bank.party_name “bank_name” ,branch.bank_branch_name “Branch_Name” ,accts.country_code “account_country_code” ,accts.bank_account_name “Account_Name” ,accts.bank_account_num “Account_Number”…
Read MoreThis query fetches cumulative inventory stock position for a particular period. select :p_from_date fromdate,:p_to_date todate, msi.inventory_item_id, msi.segment1, msi.primary_uom_code uom, (select (sum(mmt.primary_quantity)) from…
Read MoreThis 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. SELECT ei.expenditure_id,…
Read MoreINVALID DISTRIBUTION ACCT DUPLICATE LINE NUMBER ZX_IMP_TAX_RATE_AMT_MISMATCH NO EXCHANGE RATE INVALID ASSIGNMENT INVALID DISTRIBUTION ACCT …
Read MoreThe below query fetches all the supplier information including GST Info select (select name from hr_operating_units where organization_id=jpr.org_id) Operating_unit, APS.VENDOR_NAME supplier_name, APSA.…
Read MoreBelow procedure will create Supplir Bank account details PROCEDURE create_banks_accounts(p_change_type VARCHAR2) AS ln_count NUMBER; ln_success_count NUMBER; ln_error_count NUMBER; ln_x_bank_id …
Read MoreBelow query will display all TDS related details for GST implementations SELECT aia.invoice_date, aia.doc_sequence_value voucher_num, aia.invoice_num, aia.invoice_amount, aps.vendor_name party_name, (SELECT t.description FROM apps.ap_invoice_distributions_all apd,…
Read MoreBelow Query will fetch Vendor Wise RO Account Ledger details SELECT * FROM (SELECT asp.vendor_id, aia.gl_date accounting_date, …
Read MoreThe below query will provide the complete breakup of posted Journals with transaction distribution wise breakup details of Fixed assets(receiving,inventory, WIP sources) sub-ledger modules. –SK Receiving Source: SELECT …
Read MoreThe below query will provide the complete breakup of posted Journals with transaction distribution wise breakup details of Fixed assets(all sources) sub-ledger modules. SELECT GCC.concatenated_segments segments, …
Read More