Account Receivable Collection Report

AIM: Bellow query is used for getting the data of AR Collection report for last four weeks in account receivable. Script: select ( SELECT TERRITORY_SHORT_NAME FROM fnd_territories_vl WHERE ...

Iexpence Report Query

AIM: This query is used for Iexpence Report query. Script: select APERH.EMPLOYEE_ID ,APERH.INVOICE_NUM EXPENSE_NUMBER ...

TDS Depot Automation Report

This Query is used for getting the AP invoice for TDS during the current financial Year. Script: SELECT SEGMENT1                 SUPPLIER_NUMBER ,VENDOR_NAME             SUPPLIER_NAME ...

Query to get Bill Code details

Introduction:-This query will provide complete Bill Code and GL String details from Back end Code:- SELECT MSIB.SEGMENT1 Catalog_Item, MSIB.INVENTORY_ITEM_STATUS_CODE STATUS, MSIB.DESCRIPTION ...

Start typing and press Enter to search