Blog / Category
Advanced Pricing
4 articles in this category
Advanced Pricing
Oracle Pricelist and Associated Items Details in Oracle Apps R12
Introduction: This query is used to retrieve the relationship between Price Lists, Items/Products, Customers, and Customer Sites in Oracle E-Business Suite. It…
Advanced Pricing
Sample code to create a Qualifier for an Existing Modifier
DECLARE lc_uom VARCHAR2 (5); lc_cust_account_id NUMBER; lc_list_type_code VARCHAR2 (150); lc_list_line_type_code VARCHAR2 (150); lc_prod_attr_value VARCHAR2 (25…
Advanced Pricing
Query to extract modifiers have been applied to a particular sales order
oracle-ebs-modifier-applied-against-so SELECT a.NAME “Modifier Name”,b.INVENTORY_ITEM_ID, b.list_line_no “Modifier Line No”, a.description “Modifier Description…
Oracle Application Blog
Item Code as Qualifier and Percentage Discounts based on Item Code
Item Code as Qualifier in Advanced Pricing Business Case: A World leading soft drinks manufacturer in Vietnam likes to implement Advance Pricing to incor…