APPS.ASO_DEAL_PUB dependencies on ASO_PAYMENTS

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 131: l_payment_term_id ASO_PAYMENTS.PAYMENT_TERM_ID%TYPE;

127: l_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
128: ln_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
129: ld_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
130: l_price_request_id ASO_QUOTE_HEADERS_ALL.PRICE_REQUEST_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;

Line 132: l_line_payment_term_id ASO_PAYMENTS.PAYMENT_TERM_ID%TYPE;

128: ln_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
129: ld_quote_status_id ASO_QUOTE_HEADERS_ALL.QUOTE_STATUS_ID%TYPE;
130: l_price_request_id ASO_QUOTE_HEADERS_ALL.PRICE_REQUEST_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;