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…
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 MoreQuery for Approval Assignments
SELECT hou.NAME operating_unit, pj.NAME job, pcf.control_function_name, pcga.control_group_name, TO_CHAR (ppca.start_date, ‘DD-MON-YY’) start_date, TO_CHAR (ppca.end_date, ‘DD-MON-YY’) end_date FROM apps.po_position_controls_all ppca, …
Read More