APPS.OE_LINE_UTIL dependencies on OE_PRICE_ADJ_ASSOCS

Line 22082: --parent line assocation id through the OE_PRICE_ADJ_ASSOCS table

22078: p_x_line_rec IN OE_Order_PUB.line_rec_type)
22079: IS
22080:
22081: --cursor to return the current line association id and the
22082: --parent line assocation id through the OE_PRICE_ADJ_ASSOCS table
22083: CURSOR C1 IS
22084: SELECT opa1.price_adjustment_id, opa2.price_adjustment_id, opa1.line_id
22085: FROM
22086: oe_price_adjustments opa1,

Line 22087: oe_price_adj_assocs opaa,

22083: CURSOR C1 IS
22084: SELECT opa1.price_adjustment_id, opa2.price_adjustment_id, opa1.line_id
22085: FROM
22086: oe_price_adjustments opa1,
22087: oe_price_adj_assocs opaa,
22088: oe_price_adjustments opa2
22089: WHERE
22090: opa1.line_id = p_old_line_rec.line_id
22091: AND opa1.price_adjustment_id = opaa.rltd_price_adj_id

Line 22157: FROM oe_price_adj_assocs opaa,oe_price_adjustments opa

22153:
22154: --Find out the number of free items adjustments associated with this parent
22155: --(other then this item, we already deleted its adjustment)
22156: SELECT COUNT(*) INTO row_count
22157: FROM oe_price_adj_assocs opaa,oe_price_adjustments opa
22158: WHERE opaa.price_adjustment_id=parent_adj_id
22159: AND opaa.rltd_price_adj_id=opa.price_adjustment_id;
22160: oe_debug_pub.ADD('total '||row_count||' free child record(s)',1);
22161:

Line 22170: (select rltd_price_adj_id from oe_price_adj_assocs

22166: WHERE price_adjustment_id=parent_adj_id;
22167: oe_debug_pub.ADD('updated parent adjustment: applied_flag=Y,updated_flag=Y:'||SQL%rowcount||' row(s)',1);
22168: UPDATE oe_price_adjustments
22169: SET updated_flag = 'Y' where price_adjustment_id in
22170: (select rltd_price_adj_id from oe_price_adj_assocs
22171: where price_adjustment_id = parent_adj_id);
22172: ELSE
22173: --the last (or only) free item, make parent adjustment applied='N'
22174: UPDATE oe_price_adjustments