Item Where Used Extract Query
Introduction: This SQL query is used to fetching the data of FG Items where used details like Component Item, Component Item Description, Parent ,Parent Item Description, Item Seq, Effettivity…
Read MoreBill of Materials Explosion Extract Query
Introduction: This SQL query is used to fetching the data of Bill of Materials Explosion details like Order Level, Root Assembly, Assembly Item, Assembly Item Description, Assembly Item Type,…
Read MoreCustomer Wise Accrual Details in Trade Management
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 MoreQuery to Extract the Credit Memo Data
Introduction 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 MorePO Receipt Details Query
Introduction 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 MoreItem Master Extract Report
Introduction 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 MoreOn hand Inventory by Revision Report
Introduction 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 MoreQuery to Extract the IPV Report Data
Introduction 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 MoreQuery to Fetch the Unapplied Receipts Report
Introduction 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 MoreQuery to fetch the Records from AP Expense to GL
Introduction 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 More