Category: OM- Order Managment

blogs related to Order Management (OM)

General Queries For Pricing In Order Management (OM)

Below query will give the information about 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

Continue reading
Copy Protected by Chetan's WP-Copyprotect.