eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_LINE_ADJ_UTIL dependencies on OE_PRICE_ADJ_ASSOCS

Line 156: from oe_price_adj_Assocs a, oe_price_adjustments b

152: ,a.PRICE_ADJ_ASSOC_ID
153: ,a.LINE_ID
154: ,a.RLTD_PRICE_ADJ_ID
155: ,a.LOCK_CONTROL
156: from oe_price_adj_Assocs a, oe_price_adjustments b
157: where a.price_adjustment_id = p_price_adjustment_id
158: and a.rltd_price_adj_id = b.price_adjustment_id
159: and b.list_line_type_code in ('SUR','DIS');
160: I PLS_INTEGER;

Line 3590: FROM OE_PRICE_ADJ_ASSOCS ASSOCS,

3586: --bug3528335 moving the following DELETE statement before deletion of the parent and checking for PBH.
3587: --bug3405372 deleting the child lines of PBH modifiers as well
3588: DELETE FROM OE_PRICE_ADJUSTMENTS
3589: WHERE PRICE_ADJUSTMENT_ID IN (SELECT RLTD_PRICE_ADJ_ID
3590: FROM OE_PRICE_ADJ_ASSOCS ASSOCS,
3591: OE_PRICE_ADJUSTMENTS PARENT
3592: WHERE ASSOCS.PRICE_ADJUSTMENT_ID=PARENT.PRICE_ADJUSTMENT_ID
3593: AND PARENT.PRICE_ADJUSTMENT_ID=p_price_adjustment_id
3594: AND PARENT.LIST_LINE_TYPE_CODE='PBH');

Line 5160: oe_price_adj_assocs a,oe_price_adjustments p

5156:
5157: SELECT 'Y'
5158: INTO l_prg_exist
5159: FROM oe_price_adjustments prg, oe_order_lines_all l,
5160: oe_price_adj_assocs a,oe_price_adjustments p
5161: WHERE prg.line_id = p_line_id
5162: AND prg.list_line_type_code = 'PRG'
5163: AND prg.price_adjustment_id = a.price_adjustment_id
5164: AND p.price_adjustment_id = a.rltd_price_adj_id

Line 5903: oe_price_adj_assocs assoc,

5899: -- Get all PRG lines
5900: Cursor prg_lines is
5901: select adj1.line_id, assoc.rltd_price_adj_id
5902: from oe_price_adjustments adj1,
5903: oe_price_adj_assocs assoc,
5904: oe_price_adjustments adj2,
5905: oe_order_lines_all line
5906: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND
5907: assoc.price_adjustment_id = adj2.price_adjustment_id AND

Line 5999: DELETE FROM OE_PRICE_ADJ_ASSOCS WHERE PRICE_ADJUSTMENT_ID = i.price_adjustment_id;

5995: oe_debug_pub.add( 'PRICE ADJ ID = ' || I.PRICE_ADJUSTMENT_ID ) ;
5996: END IF;
5997: OE_LINE_ADJ_UTIL.DELETE_ROW(p_price_adjustment_id => i.price_adjustment_id);
5998:
5999: DELETE FROM OE_PRICE_ADJ_ASSOCS WHERE PRICE_ADJUSTMENT_ID = i.price_adjustment_id;
6000: END LOOP;
6001: BEGIN
6002: l_delete_prg := 'N';
6003: SELECT price_adj_assoc_id INTO l_dummy from oe_price_adj_assocs

Line 6003: SELECT price_adj_assoc_id INTO l_dummy from oe_price_adj_assocs

5999: DELETE FROM OE_PRICE_ADJ_ASSOCS WHERE PRICE_ADJUSTMENT_ID = i.price_adjustment_id;
6000: END LOOP;
6001: BEGIN
6002: l_delete_prg := 'N';
6003: SELECT price_adj_assoc_id INTO l_dummy from oe_price_adj_assocs
6004: WHERE rltd_price_adj_id = l_rltd_price_adj_id and rownum < 2;
6005: exception
6006: WHEN NO_DATA_FOUND THEN
6007: l_delete_prg := 'Y';

Line 6873: oe_price_adj_assocs assoc,

6869: Procedure Set_PRG_Cache(p_header_id IN NUMBER) AS
6870: Cursor prg_cur is
6871: select adj1.line_id line_id
6872: from oe_price_adjustments adj1,
6873: oe_price_adj_assocs assoc,
6874: oe_price_adjustments adj2
6875: where adj1.price_adjustment_id = assoc.rltd_price_adj_id AND
6876: assoc.price_adjustment_id = adj2.price_adjustment_id AND
6877: adj2.list_line_type_code = 'PRG' AND