APPS.ASO_SUBMIT_QUOTE_PVT dependencies on ASO_PRICE_ADJ_RELATIONSHIPS

Line 2712: FROM aso_price_adj_relationships

2708: ,RLTD_PRICE_ADJ_ID
2709: ,QUOTE_SHIPMENT_ID
2710: ,SECURITY_GROUP_ID
2711: ,OBJECT_VERSION_NUMBER
2712: FROM aso_price_adj_relationships
2713: WHERE price_adjustment_id = P_Price_Adjustment_Id;
2714:
2715: -- l_price_adj_rltd_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
2716: l_price_adj_rltd_count NUMBER;

Line 2944: from aso_price_adjustments a, aso_price_adj_relationships b

2940: WHERE quote_header_id = p_qte_header_id AND
2941: quote_line_id IS NULL AND
2942: EXISTS
2943: (select NULL
2944: from aso_price_adjustments a, aso_price_adj_relationships b
2945: where a.price_adjustment_id = b.price_adjustment_id
2946: and c.price_adjustment_id = b.rltd_price_adj_id
2947: and a.quote_header_id = p_qte_header_id
2948: and a.quote_line_id IS NULL

Line 3135: from aso_price_adjustments a, aso_price_adj_relationships b

3131: WHERE quote_header_id = p_qte_header_id AND
3132: quote_line_id = p_qte_line_rec.quote_line_id AND
3133: EXISTS
3134: (select NULL
3135: from aso_price_adjustments a, aso_price_adj_relationships b
3136: where a.price_adjustment_id = b.price_adjustment_id
3137: and c.price_adjustment_id = b.rltd_price_adj_id
3138: and a.quote_header_id = p_qte_header_id
3139: and a.quote_line_id = p_qte_line_rec.quote_line_id