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_ORDER_PURGE_PVT dependencies on OE_PRICE_ADJUSTMENTS

Line 2179: WHERE (entity_id,entity_number) IN (SELECT DECODE(line_id,null,6,8),price_adjustment_id FROM oe_price_adjustments WHERE header_id=p_header_id )

2175:
2176: CURSOR c_lock_audit_hist_ent6_8 IS
2177: SELECT entity_id -- Lock all rows to be purged
2178: FROM OE_AUDIT_ATTR_HISTORY
2179: WHERE (entity_id,entity_number) IN (SELECT DECODE(line_id,null,6,8),price_adjustment_id FROM oe_price_adjustments WHERE header_id=p_header_id )
2180: FOR UPDATE NOWAIT;
2181:
2182: CURSOR c_lock_audit_hist_ent5_7 IS
2183: SELECT entity_id -- Lock all rows to be purged

Line 2221: WHERE (entity_id,entity_number) IN (SELECT DECODE(line_id,null,6,8),price_adjustment_id FROM oe_price_adjustments WHERE header_id=p_header_id );

2217: OPEN c_lock_audit_hist_ent6_8;
2218: CLOSE c_lock_audit_hist_ent6_8;
2219: DELETE
2220: FROM OE_AUDIT_ATTR_HISTORY
2221: WHERE (entity_id,entity_number) IN (SELECT DECODE(line_id,null,6,8),price_adjustment_id FROM oe_price_adjustments WHERE header_id=p_header_id );
2222:
2223:
2224: OPEN c_lock_audit_hist_ent5_7;
2225: CLOSE c_lock_audit_hist_ent5_7;

Line 2764: FROM OE_PRICE_ADJUSTMENTS

2760: RETURN VARCHAR2
2761: IS
2762: CURSOR c_header_adj IS
2763: SELECT PRICE_ADJUSTMENT_ID
2764: FROM OE_PRICE_ADJUSTMENTS
2765: WHERE HEADER_ID = p_header_id;
2766:
2767: CURSOR c_price_adj(p_price_adjustment_id NUMBER) IS
2768: SELECT price_adj_attrib_id

Line 2813: FROM oe_price_adjustments

2809:
2810: -- Lock the price adjustments record.
2811: SELECT price_adjustment_id
2812: INTO l_lock_adjustment_id
2813: FROM oe_price_adjustments
2814: WHERE price_adjustment_id = l_price_adjustment_id
2815: FOR UPDATE NOWAIT;
2816:
2817: -- Delete from price_adj_attribs.

Line 2861: DELETE FROM OE_PRICE_ADJUSTMENTS

2857: oe_debug_pub.add('Number of price_adj_assocs deleted : '||to_char(c_price_adj_assocs%ROWCOUNT),1);
2858: CLOSE c_price_adj_assocs;
2859:
2860:
2861: DELETE FROM OE_PRICE_ADJUSTMENTS
2862: WHERE price_adjustment_id = l_lock_adjustment_id;
2863:
2864: END LOOP;
2865:

Line 2899: FROM OE_PRICE_ADJUSTMENTS

2895: RETURN VARCHAR2
2896: IS
2897: CURSOR c_line_adj IS
2898: SELECT PRICE_ADJUSTMENT_ID
2899: FROM OE_PRICE_ADJUSTMENTS
2900: WHERE LINE_ID = p_line_id;
2901:
2902: -- Added cursor c_price_adj for bug # 4701261
2903:

Line 2945: FROM oe_price_adjustments

2941:
2942: -- Lock the price adjustments record.
2943: SELECT price_adjustment_id
2944: INTO l_lock_adjustment_id
2945: FROM oe_price_adjustments
2946: WHERE price_adjustment_id = l_price_adjustment_id
2947: FOR UPDATE NOWAIT;
2948:
2949:

Line 3007: DELETE FROM OE_PRICE_ADJUSTMENTS

3003:
3004: oe_debug_pub.add('Number of price_adj_assocs deleted : '||to_char(c_price_adj_assocs%ROWCOUNT),1);
3005: CLOSE c_price_adj_assocs;
3006:
3007: DELETE FROM OE_PRICE_ADJUSTMENTS
3008: WHERE price_adjustment_id = l_lock_adjustment_id;
3009:
3010: END LOOP;
3011: