DBA Data[Home] [Help]

APPS.ASO_COPY_QUOTE_PVT dependencies on ASO_PRICE_ADJ_RELATIONSHIPS

Line 2326: FROM ASO_PRICE_ADJ_RELATIONSHIPS apr

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

Line 2439: FROM ASO_PRICE_ADJ_RELATIONSHIPS apr

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

Line 5541: FROM ASO_PRICE_ADJ_RELATIONSHIPS apr

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