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_SALES_CREDITS

Line 2185: WHERE (entity_id,entity_number) IN ( SELECT DECODE(line_id,null,5,7),sales_credit_id FROM oe_sales_credits WHERE header_id=p_header_id)

2181:
2182: CURSOR c_lock_audit_hist_ent5_7 IS
2183: SELECT entity_id -- Lock all rows to be purged
2184: FROM OE_AUDIT_ATTR_HISTORY
2185: WHERE (entity_id,entity_number) IN ( SELECT DECODE(line_id,null,5,7),sales_credit_id FROM oe_sales_credits WHERE header_id=p_header_id)
2186: FOR UPDATE NOWAIT;
2187: --16193599 Audit History Purge End
2188:
2189: cursor c_purge_set_history is --bug#5631508

Line 2228: WHERE (entity_id,entity_number) IN ( SELECT DECODE(line_id,null,5,7),sales_credit_id FROM oe_sales_credits WHERE header_id=p_header_id);

2224: OPEN c_lock_audit_hist_ent5_7;
2225: CLOSE c_lock_audit_hist_ent5_7;
2226: DELETE
2227: FROM OE_AUDIT_ATTR_HISTORY
2228: WHERE (entity_id,entity_number) IN ( SELECT DECODE(line_id,null,5,7),sales_credit_id FROM oe_sales_credits WHERE header_id=p_header_id);
2229: --16193599 Audit History Purge End
2230:
2231: OPEN c_lock_header; -- Lock all rows to be purged
2232:

Line 3106: FROM OE_SALES_CREDITS

3102: IS
3103:
3104: CURSOR c_order_sales_credits IS
3105: SELECT SALES_CREDIT_ID
3106: FROM OE_SALES_CREDITS
3107: WHERE HEADER_ID = p_header_id;
3108:
3109: l_sales_credit_id NUMBER;
3110: l_lock_sales_credit_id NUMBER;

Line 3127: FROM oe_sales_credits

3123:
3124: -- Lock the sales credits record.
3125: SELECT sales_credit_id
3126: INTO l_lock_sales_credit_id
3127: FROM oe_sales_credits
3128: WHERE sales_credit_id = l_sales_credit_id
3129: FOR UPDATE NOWAIT;
3130:
3131: DELETE FROM OE_SALES_CREDITS

Line 3131: DELETE FROM OE_SALES_CREDITS

3127: FROM oe_sales_credits
3128: WHERE sales_credit_id = l_sales_credit_id
3129: FOR UPDATE NOWAIT;
3130:
3131: DELETE FROM OE_SALES_CREDITS
3132: WHERE SALES_CREDIT_ID = l_sales_credit_id;
3133:
3134: END LOOP;
3135:

Line 3168: FROM OE_SALES_CREDITS

3164: IS
3165:
3166: CURSOR c_line_sales_credits IS
3167: SELECT SALES_CREDIT_ID
3168: FROM OE_SALES_CREDITS
3169: WHERE LINE_ID = p_line_id;
3170:
3171: l_sales_credit_id NUMBER;
3172: l_lock_sales_credit_id NUMBER;

Line 3189: FROM oe_sales_credits

3185:
3186: -- Lock the sales credits record.
3187: SELECT sales_credit_id
3188: INTO l_lock_sales_credit_id
3189: FROM oe_sales_credits
3190: WHERE sales_credit_id = l_sales_credit_id
3191: FOR UPDATE NOWAIT;
3192:
3193: DELETE FROM OE_SALES_CREDITS

Line 3193: DELETE FROM OE_SALES_CREDITS

3189: FROM oe_sales_credits
3190: WHERE sales_credit_id = l_sales_credit_id
3191: FOR UPDATE NOWAIT;
3192:
3193: DELETE FROM OE_SALES_CREDITS
3194: WHERE SALES_CREDIT_ID = l_sales_credit_id;
3195:
3196: END LOOP;
3197: