eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_DEAL_PUB dependencies on ASO_PRICE_ADJUSTMENTS

Line 81: from aso_price_adjustments

77: CHANGE_REASON_CODE,
78: CHANGE_REASON_TEXT,
79: adjusted_amount,
80: automatic_flag
81: from aso_price_adjustments
82: where quote_header_id=pc_quote_header_id
83: and quote_line_id =pc_quote_line_id
84: and applied_flag='Y'
85: and modifier_line_id<>nvl(pc_modifier_line_id,-1)

Line 135: L_modifier_line_id ASO_PRICE_ADJUSTMENTS.MODIFIER_LINE_ID%TYPE;

131: l_payment_term_id ASO_PAYMENTS.PAYMENT_TERM_ID%TYPE;
132: l_line_payment_term_id ASO_PAYMENTS.PAYMENT_TERM_ID%TYPE;
133: l_shipment_method_code ASO_SHIPMENTS.SHIP_METHOD_CODE%TYPE;
134: l_line_ship_method_code ASO_SHIPMENTS.SHIP_METHOD_CODE%TYPE;
135: L_modifier_line_id ASO_PRICE_ADJUSTMENTS.MODIFIER_LINE_ID%TYPE;
136: l_price_adjustment_id ASO_PRICE_ADJUSTMENTS.PRICE_ADJUSTMENT_ID%TYPE;
137: l_applied_flag ASO_PRICE_ADJUSTMENTS.APPLIED_FLAG%TYPE;
138: l_operand ASO_PRICE_ADJUSTMENTS.OPERAND%TYPE;
139: ld_operand ASO_PRICE_ADJUSTMENTS.OPERAND%TYPE;

Line 136: l_price_adjustment_id ASO_PRICE_ADJUSTMENTS.PRICE_ADJUSTMENT_ID%TYPE;

132: l_line_payment_term_id ASO_PAYMENTS.PAYMENT_TERM_ID%TYPE;
133: l_shipment_method_code ASO_SHIPMENTS.SHIP_METHOD_CODE%TYPE;
134: l_line_ship_method_code ASO_SHIPMENTS.SHIP_METHOD_CODE%TYPE;
135: L_modifier_line_id ASO_PRICE_ADJUSTMENTS.MODIFIER_LINE_ID%TYPE;
136: l_price_adjustment_id ASO_PRICE_ADJUSTMENTS.PRICE_ADJUSTMENT_ID%TYPE;
137: l_applied_flag ASO_PRICE_ADJUSTMENTS.APPLIED_FLAG%TYPE;
138: l_operand ASO_PRICE_ADJUSTMENTS.OPERAND%TYPE;
139: ld_operand ASO_PRICE_ADJUSTMENTS.OPERAND%TYPE;
140:

Line 137: l_applied_flag ASO_PRICE_ADJUSTMENTS.APPLIED_FLAG%TYPE;

133: l_shipment_method_code ASO_SHIPMENTS.SHIP_METHOD_CODE%TYPE;
134: l_line_ship_method_code ASO_SHIPMENTS.SHIP_METHOD_CODE%TYPE;
135: L_modifier_line_id ASO_PRICE_ADJUSTMENTS.MODIFIER_LINE_ID%TYPE;
136: l_price_adjustment_id ASO_PRICE_ADJUSTMENTS.PRICE_ADJUSTMENT_ID%TYPE;
137: l_applied_flag ASO_PRICE_ADJUSTMENTS.APPLIED_FLAG%TYPE;
138: l_operand ASO_PRICE_ADJUSTMENTS.OPERAND%TYPE;
139: ld_operand ASO_PRICE_ADJUSTMENTS.OPERAND%TYPE;
140:
141:

Line 138: l_operand ASO_PRICE_ADJUSTMENTS.OPERAND%TYPE;

134: l_line_ship_method_code ASO_SHIPMENTS.SHIP_METHOD_CODE%TYPE;
135: L_modifier_line_id ASO_PRICE_ADJUSTMENTS.MODIFIER_LINE_ID%TYPE;
136: l_price_adjustment_id ASO_PRICE_ADJUSTMENTS.PRICE_ADJUSTMENT_ID%TYPE;
137: l_applied_flag ASO_PRICE_ADJUSTMENTS.APPLIED_FLAG%TYPE;
138: l_operand ASO_PRICE_ADJUSTMENTS.OPERAND%TYPE;
139: ld_operand ASO_PRICE_ADJUSTMENTS.OPERAND%TYPE;
140:
141:
142: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;

Line 139: ld_operand ASO_PRICE_ADJUSTMENTS.OPERAND%TYPE;

135: L_modifier_line_id ASO_PRICE_ADJUSTMENTS.MODIFIER_LINE_ID%TYPE;
136: l_price_adjustment_id ASO_PRICE_ADJUSTMENTS.PRICE_ADJUSTMENT_ID%TYPE;
137: l_applied_flag ASO_PRICE_ADJUSTMENTS.APPLIED_FLAG%TYPE;
138: l_operand ASO_PRICE_ADJUSTMENTS.OPERAND%TYPE;
139: ld_operand ASO_PRICE_ADJUSTMENTS.OPERAND%TYPE;
140:
141:
142: l_control_rec ASO_QUOTE_PUB.Control_Rec_Type := ASO_QUOTE_PUB.G_Miss_Control_Rec;
143: l_qte_header_rec ASO_QUOTE_PUB.qte_Header_Rec_Type:=ASO_QUOTE_PUB.G_MISS_Qte_Header_Rec;

Line 621: FROM aso_price_adjustments apa, Aso_quote_lines_all aqla

617:
618:
619: --pp_debug('in approved event price'||l_quote_line_id);
620: select count(*) into l_count_modifier
621: FROM aso_price_adjustments apa, Aso_quote_lines_all aqla
622: WHERE apa.quote_line_id = l_quote_line_id
623: AND apa.modifier_line_id = l_modifier_line_id
624: AND nvl(apa.expiration_date,sysdate) >= sysdate
625: AND apa.quote_line_id = aqla.quote_line_id;

Line 631: FROM aso_price_adjustments apa, Aso_quote_lines_all aqla

627: if l_count_modifier = 1 then
628: l_continue:='Y';
629: SELECT apa.price_adjustment_id, apa.Applied_flag, apa.Operand, aqla.line_quote_price
630: into l_price_adjustment_id,l_applied_flag,l_operand,l_line_quote_price
631: FROM aso_price_adjustments apa, Aso_quote_lines_all aqla
632: WHERE apa.quote_line_id = l_quote_line_id
633: AND apa.modifier_line_id = l_modifier_line_id
634: AND nvl(apa.expiration_date,sysdate) >= sysdate
635: AND apa.quote_line_id = aqla.quote_line_id;