APPS.ASO_SUBMIT_QUOTE_PVT dependencies on ASO_PRICE_ADJ_RELATIONSHIPS

Line 2559: FROM aso_price_adj_relationships

2555: ,RLTD_PRICE_ADJ_ID
2556: ,QUOTE_SHIPMENT_ID
2557: ,SECURITY_GROUP_ID
2558: ,OBJECT_VERSION_NUMBER
2559: FROM aso_price_adj_relationships
2560: WHERE price_adjustment_id = P_Price_Adjustment_Id;
2561:
2562: -- l_price_adj_rltd_rec ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type;
2563: l_price_adj_rltd_count NUMBER;

Line 2791: from aso_price_adjustments a, aso_price_adj_relationships b

2787: WHERE quote_header_id = p_qte_header_id AND
2788: quote_line_id IS NULL AND
2789: EXISTS
2790: (select NULL
2791: from aso_price_adjustments a, aso_price_adj_relationships b
2792: where a.price_adjustment_id = b.price_adjustment_id
2793: and c.price_adjustment_id = b.rltd_price_adj_id
2794: and a.quote_header_id = p_qte_header_id
2795: and a.quote_line_id IS NULL

Line 2982: from aso_price_adjustments a, aso_price_adj_relationships b

2978: WHERE quote_header_id = p_qte_header_id AND
2979: quote_line_id = p_qte_line_rec.quote_line_id AND
2980: EXISTS
2981: (select NULL
2982: from aso_price_adjustments a, aso_price_adj_relationships b
2983: where a.price_adjustment_id = b.price_adjustment_id
2984: and c.price_adjustment_id = b.rltd_price_adj_id
2985: and a.quote_header_id = p_qte_header_id
2986: and a.quote_line_id = p_qte_line_rec.quote_line_id