General Queries For Pricing In 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 MP WHERE     QL.LIST_HEADER_ID = QPHT.LIST_HEADER_ID AND QL.LIST_HEADER_ID = QA.LIST_HEADER_ID AND QL.LIST_LINE_ID = QA.LIST_LINE_ID AND TRUNC […]

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