SQL Queries

Employee Assignment Details Query

Introduction This Post Provides the SQL Query that returns the Assignment Details of the Employees Query SELECT peo.person_number employee_number, loc.internal_location_code location_code, loc.location_name LOCATION, per_name.last_name, per_name.first_name, per_name.middle_names middle_name, pa.address_line_1, pa.address_line_2,…

Query to Fetch Invoice details, HSN Code, Third party Registration number and GST Details.

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 a.org_id,a.customer_trx_id,a.trx_number…

Return To Vendor Summay-GST

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 etc..…

Delivery Challan with GST Details

Query retrieves data of those inventory items which are used for promotional purposes or given as a sample items for a sales executive in order to promote the products along…

Find the query of Receivable (AR) for the Invoice Number (TRX_NUMBER) Wise, Customer wise, Sales Order Wise, Transaction Date and GL Date Wise in Oracle Apps EBS R12

Find the query of Receivable (AR) for the Invoice Number (TRX_NUMBER) Wise, Customer wise, Sales Order Wise, Transaction Date and GL Date Wise in Oracle Apps EBS R12. SELECT rct.trx_number…

Query to get transactions of inventory items with available onhand quantity

SELECT recs.doc_type, recs.item_number, recs.doc_no, recs.po_number, recs.organization_id, recs.inventory_item_id, recs.primary_quantity, recs.transaction_date FROM ( /* receipt transactions*/ …

Query to get current onhand quantity of inventory Items.

SELECT ALL mtl.organization_id, orgs.NAME organization_name, mtl.inventory_item_id, mtl.segment1 item_number, mtl.description item_description, mtl.item_type, mtl.inventory_item_status_code, mtl.primary_uom_code, …

Payroll Employer Costs Extract

SELECT SUM(peevf.screen_entry_value) FROM pay_element_types_f petf ,pay_element_entry_values_f peevf ,pay_element_entries_f peef ,per_all_assignments_f paaf ,pay_input_values_f pivf WHERE paaf.assignment_id = p_assignment_id AND p_effective_date between paaf.effective_start_date and paaf.effective_end_date AND peef.assignment_id = paaf.assignment_id AND peef.effective_start_date between…

AP Supplier Banks Payments Query

SELECT pvs.org_id org_id, iep.default_payment_method_code, alc.lookup_code, hou.NAME org_name, pv.vendor_id supplier_id, pv.segment1 supplier_number, plc.description supplier_type, pv.vendor_name supplier_name, …

Sales Order details with India Localization tax

SELECT h.header_id header_id, party.party_name sold_to, h.order_number order_number, NVL (TO_CHAR (h.ordered_date, ‘DD-MON-YYYY’), TO_CHAR (h.request_date, ‘DD-MON-YYYY’) …

We take you from best practices to next practices of software implementation

Solutions that Ensure You Stay Ahead of Competition

Your Partner for Strategic Technology Solutions

Guiding Your Digital Transformation Journey