OM- Order Managment

General Queries For Pricing In Order Management (OM)

The blog provides the commonly used Oracle EBS R12 Pricing SQL Queries in Order Management EBS R12 SQL to get active prices of an item available in different price lists SELECT TO_CHAR (QL.OPERAND) UNIT_PRICE, QL.LIST_HEADER_ID PRICE_LIST_ID, QPHT.NAME PRICE_LIST_NAME, QL.END_DATE_ACTIVE PRICE_LIST_END_DATE, MSI.SEGMENT1 ITEM_NAME, QL.LAST_UPDATE_DATE FROM APPS.QP_LIST_LINES QL, APPS.QP_PRICING_ATTRIBUTES QA, QP_LIST_HEADERS_TL QPHT, MTL_SYSTEM_ITEMS_B MSI, APPS.MTL_PARAMETERS MP WHERE     […]

Scroll to top
Copy Protected by Chetan's WP-Copyprotect.