Inventory Onhand By Location Report
Introduction: This SQL query is used to fetch the data Inventory Onhand By Location Cause of the issue: Business wants a report that details Inventory Onhand By Location How do…
Read MoreBacklog Report With Freight Details
Introduction: This SQL query is used to fetching the data Backlog Orders with freight Details Cause of the issue: Business wants a report that details of Backlog Orders…
Read MoreItem 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 More