DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_PRICE_ADJ_RELATIONSHIPS

Line 1631: FROM ASO_PRICE_ADJ_RELATIONSHIPS apr

1627: , apr.LAST_UPDATE_LOGIN, apr.PROGRAM_APPLICATION_ID
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'

Line 1744: FROM ASO_PRICE_ADJ_RELATIONSHIPS apr

1740: , apr.PROGRAM_ID, apr.PROGRAM_UPDATE_DATE, apr.REQUEST_ID
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

Line 4233: FROM ASO_PRICE_ADJ_RELATIONSHIPS apr

4229: , apr.LAST_UPDATE_LOGIN, apr.PROGRAM_APPLICATION_ID
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