APPS.ASO_QUOTE_LINES_PVT dependencies on ASO_PRICE_ADJ_RELATIONSHIPS

Line 4757: from aso_price_adj_relationships a

4753: --New Code for updating PBH
4754:
4755: cursor c_pbh( p_price_adjustment_id number ) is
4756: select price_adjustment_id
4757: from aso_price_adj_relationships a
4758: where a.price_adjustment_id = ( select price_adjustment_id
4759: from aso_price_adjustments b
4760: where a.price_adjustment_id = b.price_adjustment_id
4761: and b.MODIFIER_LINE_TYPE_CODE = 'PBH')

Line 8374: FROM aso_price_adj_relationships b

8370: UPDATE aso_price_adjustments
8371: SET updated_flag = 'Y',
8372: applied_flag = null
8373: Where price_adjustment_id in ( SELECT rltd_price_adj_id
8374: FROM aso_price_adj_relationships b
8375: WHERE price_adjustment_id = l_price_adjustment_id );
8376:
8377: --update the parent PBH line
8378: UPDATE aso_price_adjustments

Line 9274: from aso_price_adjustments a, aso_price_adj_relationships b

9270: and modifier_line_type_code = G_PROMO_GOODS_DISCOUNT;
9271:
9272: cursor c_free_lines is
9273: select a.quote_line_id
9274: from aso_price_adjustments a, aso_price_adj_relationships b
9275: where a.price_adjustment_id = b.rltd_price_adj_id
9276: and b.quote_line_id = p_qte_line_rec.quote_line_id
9277: and a.quote_line_id <> p_qte_line_rec.quote_line_id;
9278:

Line 9513: from aso_price_adj_relationships rel,

9509:
9510: select rel.rltd_price_adj_id
9511: BULK COLLECT INTO
9512: adj_id_tbl
9513: from aso_price_adj_relationships rel,
9514: aso_price_adjustments adj
9515: where rel.price_adjustment_id = adj.price_adjustment_id
9516: and adj.modifier_line_type_code = G_PROMO_GOODS_DISCOUNT
9517: and rel.price_adjustment_id in (select a.price_adjustment_id

Line 9518: from aso_price_adj_relationships a,

9514: aso_price_adjustments adj
9515: where rel.price_adjustment_id = adj.price_adjustment_id
9516: and adj.modifier_line_type_code = G_PROMO_GOODS_DISCOUNT
9517: and rel.price_adjustment_id in (select a.price_adjustment_id
9518: from aso_price_adj_relationships a,
9519: aso_price_adjustments b
9520: where a.rltd_price_adj_id = b.price_adjustment_id
9521: and b.quote_line_id = p_qte_line_rec.quote_line_id);
9522:

Line 9559: from aso_price_adj_relationships a, aso_price_adjustments b

9555:
9556: select a.price_adjustment_id
9557: BULK COLLECT INTO
9558: adj_id_tbl
9559: from aso_price_adj_relationships a, aso_price_adjustments b
9560: where a.rltd_price_adj_id = b.price_adjustment_id
9561: and b.quote_line_id = p_qte_line_rec.quote_line_id;
9562:
9563: if aso_debug_pub.g_debug_flag = 'Y' THEN