Introduction This Query will help to Extract the Customer Wise Accrual Details in Trade Management in Oracle Apps. SQL Query: SELECT DECODE (qualifier_context, ‘CUSTOMER’, (SELECT b.party_name FROM hz_cust_accounts a, hz_parties…
Read MoreIntroduction This Query will help to Extract the Credit Memo Data in Oracle Apps. SQL Query: SELECT CASE rcta.interface_header_context WHEN ‘CLAIM’ THEN ‘TRADE MANAGEMENT’ WHEN ‘ORDER ENTRY’ THEN ‘Order Entry…
Read MoreIntroduction This Query will help to Fetch PO Receipt Details Data in Oracle Apps. SQL Query: SELECT pv.vendor_name, poh.ship_to_location, poh.bill_to_location, DECODE (plla.match_option, ‘P’, ‘PO’, ‘R’, ‘Receipt’, ”) line_status, UPPER (poh.status)…
Read MoreIntroduction This Query will help to Fetch the Item Master Extract Report Data in Oracle Apps. SQL Query: SELECT DISTINCT (SELECT organization_code FROM mtl_parameters WHERE organization_id = msi.organization_id AND ROWNUM…
Read MoreIntroduction This Query will help to Fetch the On hand Inventory by Revision Report Data in Oracle Apps. SQL Query: /* Formatted on 2021/09/06 15:26 (Formatter Plus v4.8.8) */ SELECT…
Read MoreIntroduction This Query will help to Fetch the IPV Report Data in Oracle Apps. SQL Query: BEGIN fnd_client_info.set_org_context (:p_org); END; SELECT glps.set_of_books_id, msi.organization_id, pov.vendor_id, glps.period_name, api.invoice_num invoice_num, aid.accounting_date invoice_date, DECODE…
Read MoreIntroduction This Query will help to Fetch the Unapplied Receipts Report Data SQL Query: SELECT COMPANY COMPANY, CASE WHEN CUSTOMER_NAME IS NULL THEN ‘ **** Unidentified’ ELSE CUSTOMER_NAME END CUSTOMER_NAME,…
Read MoreIntroduction This Query will help to Fetch Records From AP Expense to GL SQL Query: SELECT aerha.invoice_num expense_invoice_number, papf.full_name employee_name, aerha.SOURCE, aerha.description expense_header_description, aerha.attribute_category, aerha.expense_status_code, aerla.start_expense_date, aerla.distribution_line_number, aerla.item_description line_description, aerla.amount,…
Read MoreOnhand Inventory by Revision Report Introduction This Query will help to generate the On-hand Inventory by Revision Report Script: Step 1: Create Package Spec CREATE OR REPLACE PACKAGE xxxx_inventory_pkg AS…
Read MoreSQL Query to Extract the Corporate Card Inter-Company Accounting Details in Oracle APPS R12 Introduction This script will help to extract the complete Corporate Card Inter-Company Accounting Details in Oracle…
Read More