APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_PRICE_ADJUSTMENTS

Line 1632: , ASO_PRICE_ADJUSTMENTS apa

1628: , apr.PROGRAM_ID, apr.PROGRAM_UPDATE_DATE, apr.REQUEST_ID
1629: , apr.QUOTE_LINE_ID, apr.PRICE_ADJUSTMENT_ID
1630: , apr.RLTD_PRICE_ADJ_ID , apr.OBJECT_VERSION_NUMBER
1631: FROM ASO_PRICE_ADJ_RELATIONSHIPS apr
1632: , ASO_PRICE_ADJUSTMENTS apa
1633: WHERE apr.price_adjustment_id = apa.price_adjustment_id
1634: AND apa.quote_header_id = x_quote_header_id
1635: AND EXISTS ( SELECT 'x'
1636: FROM aso_quote_lines_all aql

Line 1745: , ASO_PRICE_ADJUSTMENTS apa

1741: , apr.QUOTE_LINE_ID, apr.PRICE_ADJUSTMENT_ID
1742: , apr.RLTD_PRICE_ADJ_ID
1743: , apr.OBJECT_VERSION_NUMBER
1744: FROM ASO_PRICE_ADJ_RELATIONSHIPS apr
1745: , ASO_PRICE_ADJUSTMENTS apa
1746: WHERE apr.price_adjustment_id = apa.price_adjustment_id
1747: AND apr.quote_line_id = x_quote_line_id
1748: AND apa.quote_line_id = x_quote_line_id
1749: AND apa.modifier_line_type_code <> 'PRG';

Line 4234: , ASO_PRICE_ADJUSTMENTS apa

4230: , apr.PROGRAM_ID, apr.PROGRAM_UPDATE_DATE, apr.REQUEST_ID
4231: , apr.QUOTE_LINE_ID, apr.PRICE_ADJUSTMENT_ID
4232: , apr.RLTD_PRICE_ADJ_ID, apr.OBJECT_VERSION_NUMBER
4233: FROM ASO_PRICE_ADJ_RELATIONSHIPS apr
4234: , ASO_PRICE_ADJUSTMENTS apa
4235:
4236: WHERE apr.price_adjustment_id = apa.price_adjustment_id
4237: AND apr.quote_line_id = x_quote_line_id
4238: AND apa.quote_line_id = x_quote_line_id