APPS.ASO_DEAL_PUB dependencies on ASO_QUOTE_LINES_ALL

Line 44: FROM aso_quote_lines_all aqla, aso_shipments aship,aso_payments apay

40: -- for fetching line level details
41: CURSOR C_quote_line(pc_quote_line_id NUMBER)
42: IS
43: SELECT aqla.line_quote_price,aqla.quantity, nvl(aship.ship_method_code,'X') ship_method_code,nvl(payment_term_id,-1) payment_term_id,nvl(PRICING_LINE_TYPE_INDICATOR,'XXX') PRICING_LINE_TYPE_INDICATOR
44: FROM aso_quote_lines_all aqla, aso_shipments aship,aso_payments apay
45: WHERE aqla.quote_line_id = pc_quote_line_id
46: AND aqla.quote_line_id = aship.quote_line_id (+)
47: AND aqla.quote_line_id = apay.quote_line_id (+) ;
48:

Line 116: l_pricing_line_type_indicator ASO_QUOTE_LINES_ALL.PRICING_LINE_TYPE_INDICATOR%type;

112: l_ordered_qty NUMBER;
113: l_line_qty NUMBER;
114: l_modifier_name varchar2(240);
115: ln_count NUMBER:=0;
116: l_pricing_line_type_indicator ASO_QUOTE_LINES_ALL.PRICING_LINE_TYPE_INDICATOR%type;
117:
118: -- For multi-row query dynamic execution
119: TYPE PRCCURREF is REF CURSOR;
120: prcadj_cv PRCCURREF;

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;

Line 811: Update aso_quote_lines_all

807: aso_debug_pub.add('ASO_DEAL_PUB: after Update_Quote', 1, 'Y');
808: END IF;
809:
810: if x_return_status = FND_API.G_RET_STS_SUCCESS then
811: Update aso_quote_lines_all
812: set PRICING_LINE_TYPE_INDICATOR=NULL
813: where quote_header_id = p_quote_header_id
814: and PRICING_LINE_TYPE_INDICATOR='D';
815: