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..…
Read MoreDelivery 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…
Read MoreFind 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…
Read MoreQuery 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*/ …
Read MoreQuery 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, …
Read MorePayroll 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…
Read MoreAP 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, …
Read MoreSales 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’) …
Read MoreQuery to get opening,purchasing,receive,sales and closing quantity of items
SELECT * FROM (SELECT b.item_code, b.item_description item_description, b.primary_uom, b.sub_inventory, b.LOCATOR, b.opening_qty opening_qty,…
Read MoreQuery for Approval groups
SELECT pcr.control_rule_id, pcga.control_group_name, pcr.object_code, pcr.rule_type_code, pcr.amount_limit, ( segment1_low || ‘.’ || segment2_low …
Read More