Search This Blog

Saturday, April 7, 2012

SQL Query to extract Oracle Sales Order Price Adjustments

select
ADJ.PRICE_ADJUSTMENT_ID            PRC_ADJ_ID,
nvl(ADJ.APPLIED_FLAG,'N')          APPLIED_FLAG,
ADJ.LIST_HEADER_ID                 LST_HD_ID,
ADJ.LIST_LINE_ID                   LST_LN_ID,
ADJ.LIST_LINE_NO                   LIST_LN_NO,  
ADJ.MODIFIER_LEVEL_CODE            MOD_LVL,    
ADJ.LIST_LINE_TYPE_CODE            LIST_TYPE_CODE,
ADJ.CHARGE_TYPE_CODE               CHG_TY_CD,            
ADJ.ARITHMETIC_OPERATOR            ARITH_OP, 
ADJ.OPERAND_PER_PQTY               OP_PER_QTY,       
ADJ.ADJUSTED_AMOUNT_PER_PQTY       ADJ_AMT_PQ,
ADJ.OPERAND                        OPERAND,                     
ADJ.ADJUSTED_AMOUNT                ADJ_AMT,                            
ADJ.CREDIT_OR_CHARGE_FLAG          CD,                         
ADJ.AUTOMATIC_FLAG                 AF,  
ADJ.PRINT_ON_INVOICE_FLAG          PI,  
ADJ.INVOICED_FLAG                  INF,             
ADJ.PERCENT                        PERC,           
ADJ.COST_ID                        COST_ID,              
adj.tax_code                       tax_code              
from oe_price_adjustments   adj,
oe_order_headers_all ooha
where  1=1
and adj.header_id                 = ooha.header_id
and ooha.order_number = &ORDER_NUMBER
        and  ADJ.LINE_ID              IS NULL
order by adj.applied_flag,list_type_code;

No comments:

Post a Comment