APPS.ASO_SUBMIT_QUOTE_PVT dependencies on ASO_PRICE_ADJUSTMENTS

Line 2848: FROM ASO_PRICE_ADJUSTMENTS

2844: CHANGE_SEQUENCE,
2845: LIST_HEADER_ID,
2846: LIST_LINE_ID,
2847: QUOTE_SHIPMENT_ID
2848: FROM ASO_PRICE_ADJUSTMENTS
2849: WHERE quote_header_id = p_qte_header_id AND
2850: quote_line_id is null AND
2851: (applied_flag IS NOT NULL AND applied_flag = 'Y')
2852: UNION ALL

Line 2939: FROM ASO_PRICE_ADJUSTMENTS c

2935: CHANGE_SEQUENCE,
2936: LIST_HEADER_ID,
2937: LIST_LINE_ID,
2938: QUOTE_SHIPMENT_ID
2939: FROM ASO_PRICE_ADJUSTMENTS c
2940: WHERE quote_header_id = p_qte_header_id AND
2941: quote_line_id IS NULL AND
2942: EXISTS
2943: (select NULL

Line 2944: from aso_price_adjustments a, aso_price_adj_relationships b

2940: WHERE quote_header_id = p_qte_header_id AND
2941: quote_line_id IS NULL AND
2942: EXISTS
2943: (select NULL
2944: from aso_price_adjustments a, aso_price_adj_relationships b
2945: where a.price_adjustment_id = b.price_adjustment_id
2946: and c.price_adjustment_id = b.rltd_price_adj_id
2947: and a.quote_header_id = p_qte_header_id
2948: and a.quote_line_id IS NULL

Line 3039: FROM ASO_PRICE_ADJUSTMENTS

3035: CHANGE_SEQUENCE,
3036: LIST_HEADER_ID,
3037: LIST_LINE_ID,
3038: QUOTE_SHIPMENT_ID
3039: FROM ASO_PRICE_ADJUSTMENTS
3040: WHERE quote_header_id = p_qte_header_id AND
3041: quote_line_id = p_qte_line_rec.quote_line_id AND
3042: (applied_flag IS NOT NULL AND applied_flag = 'Y')
3043: UNION ALL

Line 3130: FROM ASO_PRICE_ADJUSTMENTS c

3126: CHANGE_SEQUENCE,
3127: LIST_HEADER_ID,
3128: LIST_LINE_ID,
3129: QUOTE_SHIPMENT_ID
3130: FROM ASO_PRICE_ADJUSTMENTS c
3131: WHERE quote_header_id = p_qte_header_id AND
3132: quote_line_id = p_qte_line_rec.quote_line_id AND
3133: EXISTS
3134: (select NULL

Line 3135: from aso_price_adjustments a, aso_price_adj_relationships b

3131: WHERE quote_header_id = p_qte_header_id AND
3132: quote_line_id = p_qte_line_rec.quote_line_id AND
3133: EXISTS
3134: (select NULL
3135: from aso_price_adjustments a, aso_price_adj_relationships b
3136: where a.price_adjustment_id = b.price_adjustment_id
3137: and c.price_adjustment_id = b.rltd_price_adj_id
3138: and a.quote_header_id = p_qte_header_id
3139: and a.quote_line_id = p_qte_line_rec.quote_line_id

Line 3465: FROM ASO_PRICE_ADJUSTMENTS

3461: CHANGE_SEQUENCE,
3462: LIST_HEADER_ID,
3463: LIST_LINE_ID,
3464: QUOTE_SHIPMENT_ID
3465: FROM ASO_PRICE_ADJUSTMENTS
3466: WHERE quote_header_id = p_qte_header_id AND
3467: (quote_line_id = p_qte_line_id OR
3468: (quote_line_id IS NULL AND p_qte_line_id IS NULL)) AND
3469: (applied_flag IS NOT NULL AND applied_flag = 'Y');