product service relationship

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.