APPS.OE_LINE_UTIL dependencies on OE_PRICE_ADJ_ASSOCS

Line 4215: FROM oe_price_adjustments prg, oe_price_adj_assocs a,

4211:
4212:
4213: SELECT 'Y'
4214: INTO l_prg
4215: FROM oe_price_adjustments prg, oe_price_adj_assocs a,
4216: oe_price_adjustments p
4217: WHERE prg.line_id = p_x_line_rec.service_reference_line_id
4218: AND prg.list_line_type_code = 'PRG'
4219: AND prg.price_adjustment_id = a.price_adjustment_id

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

23962: p_x_line_rec IN OE_Order_PUB.line_rec_type)
23963: IS
23964:
23965: --cursor to return the current line association id and the
23966: --parent line assocation id through the OE_PRICE_ADJ_ASSOCS table
23967: CURSOR C1 IS
23968: SELECT opa1.price_adjustment_id, opa2.price_adjustment_id, opa1.line_id
23969: FROM
23970: oe_price_adjustments opa1,

Line 23971: oe_price_adj_assocs opaa,

23967: CURSOR C1 IS
23968: SELECT opa1.price_adjustment_id, opa2.price_adjustment_id, opa1.line_id
23969: FROM
23970: oe_price_adjustments opa1,
23971: oe_price_adj_assocs opaa,
23972: oe_price_adjustments opa2
23973: WHERE
23974: opa1.line_id = p_old_line_rec.line_id
23975: AND opa1.price_adjustment_id = opaa.rltd_price_adj_id

Line 24041: FROM oe_price_adj_assocs opaa,oe_price_adjustments opa

24037:
24038: --Find out the number of free items adjustments associated with this parent
24039: --(other then this item, we already deleted its adjustment)
24040: SELECT COUNT(*) INTO row_count
24041: FROM oe_price_adj_assocs opaa,oe_price_adjustments opa
24042: WHERE opaa.price_adjustment_id=parent_adj_id
24043: AND opaa.rltd_price_adj_id=opa.price_adjustment_id;
24044: oe_debug_pub.ADD('total '||row_count||' free child record(s)',1);
24045:

Line 24054: (select rltd_price_adj_id from oe_price_adj_assocs

24050: WHERE price_adjustment_id=parent_adj_id;
24051: oe_debug_pub.ADD('updated parent adjustment: applied_flag=Y,updated_flag=Y:'||SQL%rowcount||' row(s)',1);
24052: UPDATE oe_price_adjustments
24053: SET updated_flag = 'Y' where price_adjustment_id in
24054: (select rltd_price_adj_id from oe_price_adj_assocs
24055: where price_adjustment_id = parent_adj_id);
24056: ELSE
24057: --the last (or only) free item, make parent adjustment applied='N'
24058: UPDATE oe_price_adjustments

Line 24836: FROM oe_price_adj_assocs a,

24832: BEGIN
24833:
24834: SELECT a.price_adjustment_id,a.rltd_price_adj_id,prg.list_line_id,p.list_line_id
24835: INTO l_orig_pr_adjustment_id,l_or_rltd_padj_id,l_prg_list_line_id,l_assoc_list_line_id
24836: FROM oe_price_adj_assocs a,
24837: oe_price_adjustments p,
24838: oe_order_lines_all l,
24839: oe_price_adjustments prg
24840: WHERE l.line_id = p.line_id AND p.price_adjustment_id = a.rltd_price_adj_id