Introduction: We have a requirement when the new pricelist has been created that needs to be updated in the customer master account level and Bill To and Ship To level, blow code will help to [...]

Introduction: We have a Receipt with a “Claim Investigation” where the Claim # was not populated. The below script will help to resolve that issue.   w do we solve:   DECLARE [...]

 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 we solve: Create [...]

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 How do we [...]

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, [...]

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 [...]

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 [...]

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’ [...]

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, [...]

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 = [...]