Query for AR to GL in 11i

Introduction: This Post illustrates the steps required to fetch data from AR to GL  in Oracle EBS 11i.   Script SELECT je_header_id, line_number, trx_number, item_number, customer_number, ...

Query for Open Work Order

Introduction: This Post illustrates the steps required to Fetch Open work orders in Oracle EBS. Query to Fetch the Open Work Orders   SELECT DISTINCT a.job, a.item item, a.item_description, ...

Query for Open sales Order

Introduction: This Post illustrates the steps required to Fetch Open sales orders in Oracle EBS. Script to Fetch the Open sales Orders   SELECT customer_number, customer_name, ...

Start typing and press Enter to search