APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_PRICE_ADJUSTMENTS

Line 2327: , ASO_PRICE_ADJUSTMENTS apa

2323: , apr.PROGRAM_ID, apr.PROGRAM_UPDATE_DATE, apr.REQUEST_ID
2324: , apr.QUOTE_LINE_ID, apr.PRICE_ADJUSTMENT_ID
2325: , apr.RLTD_PRICE_ADJ_ID , apr.OBJECT_VERSION_NUMBER
2326: FROM ASO_PRICE_ADJ_RELATIONSHIPS apr
2327: , ASO_PRICE_ADJUSTMENTS apa
2328: WHERE apr.price_adjustment_id = apa.price_adjustment_id
2329: AND apa.quote_header_id = x_quote_header_id
2330: AND EXISTS ( SELECT 'x'
2331: FROM aso_quote_lines_all aql

Line 2440: , ASO_PRICE_ADJUSTMENTS apa

2436: , apr.QUOTE_LINE_ID, apr.PRICE_ADJUSTMENT_ID
2437: , apr.RLTD_PRICE_ADJ_ID
2438: , apr.OBJECT_VERSION_NUMBER
2439: FROM ASO_PRICE_ADJ_RELATIONSHIPS apr
2440: , ASO_PRICE_ADJUSTMENTS apa
2441: WHERE apr.price_adjustment_id = apa.price_adjustment_id
2442: AND apr.quote_line_id = x_quote_line_id
2443: AND apa.quote_line_id = x_quote_line_id
2444: AND apa.modifier_line_type_code <> 'PRG';

Line 5542: , ASO_PRICE_ADJUSTMENTS apa

5538: , apr.PROGRAM_ID, apr.PROGRAM_UPDATE_DATE, apr.REQUEST_ID
5539: , apr.QUOTE_LINE_ID, apr.PRICE_ADJUSTMENT_ID
5540: , apr.RLTD_PRICE_ADJ_ID, apr.OBJECT_VERSION_NUMBER
5541: FROM ASO_PRICE_ADJ_RELATIONSHIPS apr
5542: , ASO_PRICE_ADJUSTMENTS apa
5543:
5544: WHERE apr.price_adjustment_id = apa.price_adjustment_id
5545: AND apr.quote_line_id = x_quote_line_id
5546: AND apa.quote_line_id = x_quote_line_id