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 provides a consolidated view of price list assignments,…

Read More

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); lc_segment_mapping_column VARCHAR2 (150); lc_prc_context_name VARCHAR2 (150); lc_prc_mapping_column VARCHAR2 (150); lc_prcing_context_name VARCHAR2 (150); lc_account_number VARCHAR2 (15);…

Read More

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”, a.comments, b.list_line_type_code, d.qualifier_context, a.orig_org_id, a.active_flag, b.start_date_active, b.end_date_active, a.list_type_code, b.modifier_level_code, b.organization_id, f.order_number, b.pricing_phase_id, b.last_update_date, b.list_line_no, d.header_quals_exist_flag, d.qualifier_datatype, d.qualifier_attribute, d.segment_id,…

Read More

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 incorporate promotion, Deal and Discount for…

Read More