APPS.ASO_SUBMIT_QUOTE_PVT dependencies on ASO_PRICE_ADJUSTMENTS

Line 2695: FROM ASO_PRICE_ADJUSTMENTS

2691: CHANGE_SEQUENCE,
2692: LIST_HEADER_ID,
2693: LIST_LINE_ID,
2694: QUOTE_SHIPMENT_ID
2695: FROM ASO_PRICE_ADJUSTMENTS
2696: WHERE quote_header_id = p_qte_header_id AND
2697: quote_line_id is null AND
2698: (applied_flag IS NOT NULL AND applied_flag = 'Y')
2699: UNION ALL

Line 2786: FROM ASO_PRICE_ADJUSTMENTS c

2782: CHANGE_SEQUENCE,
2783: LIST_HEADER_ID,
2784: LIST_LINE_ID,
2785: QUOTE_SHIPMENT_ID
2786: FROM ASO_PRICE_ADJUSTMENTS c
2787: WHERE quote_header_id = p_qte_header_id AND
2788: quote_line_id IS NULL AND
2789: EXISTS
2790: (select NULL

Line 2791: from aso_price_adjustments a, aso_price_adj_relationships b

2787: WHERE quote_header_id = p_qte_header_id AND
2788: quote_line_id IS NULL AND
2789: EXISTS
2790: (select NULL
2791: from aso_price_adjustments a, aso_price_adj_relationships b
2792: where a.price_adjustment_id = b.price_adjustment_id
2793: and c.price_adjustment_id = b.rltd_price_adj_id
2794: and a.quote_header_id = p_qte_header_id
2795: and a.quote_line_id IS NULL

Line 2886: FROM ASO_PRICE_ADJUSTMENTS

2882: CHANGE_SEQUENCE,
2883: LIST_HEADER_ID,
2884: LIST_LINE_ID,
2885: QUOTE_SHIPMENT_ID
2886: FROM ASO_PRICE_ADJUSTMENTS
2887: WHERE quote_header_id = p_qte_header_id AND
2888: quote_line_id = p_qte_line_rec.quote_line_id AND
2889: (applied_flag IS NOT NULL AND applied_flag = 'Y')
2890: UNION ALL

Line 2977: FROM ASO_PRICE_ADJUSTMENTS c

2973: CHANGE_SEQUENCE,
2974: LIST_HEADER_ID,
2975: LIST_LINE_ID,
2976: QUOTE_SHIPMENT_ID
2977: FROM ASO_PRICE_ADJUSTMENTS c
2978: WHERE quote_header_id = p_qte_header_id AND
2979: quote_line_id = p_qte_line_rec.quote_line_id AND
2980: EXISTS
2981: (select NULL

Line 2982: from aso_price_adjustments a, aso_price_adj_relationships b

2978: WHERE quote_header_id = p_qte_header_id AND
2979: quote_line_id = p_qte_line_rec.quote_line_id AND
2980: EXISTS
2981: (select NULL
2982: from aso_price_adjustments a, aso_price_adj_relationships b
2983: where a.price_adjustment_id = b.price_adjustment_id
2984: and c.price_adjustment_id = b.rltd_price_adj_id
2985: and a.quote_header_id = p_qte_header_id
2986: and a.quote_line_id = p_qte_line_rec.quote_line_id

Line 3312: FROM ASO_PRICE_ADJUSTMENTS

3308: CHANGE_SEQUENCE,
3309: LIST_HEADER_ID,
3310: LIST_LINE_ID,
3311: QUOTE_SHIPMENT_ID
3312: FROM ASO_PRICE_ADJUSTMENTS
3313: WHERE quote_header_id = p_qte_header_id AND
3314: (quote_line_id = p_qte_line_id OR
3315: (quote_line_id IS NULL AND p_qte_line_id IS NULL)) AND
3316: (applied_flag IS NOT NULL AND applied_flag = 'Y');