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.OZF_OFFER_BACKDATE_PVT dependencies on OZF_OFFER_ADJUSTMENT_LINES

Line 1157: SELECT ozf_OFFER_ADJUSTMENT_LINES_s.NEXTVAL

1153: SELECT ozf_OFFER_ADJUSTMENTS_B_s.NEXTVAL
1154: FROM dual;
1155:
1156: CURSOR c_line_id IS
1157: SELECT ozf_OFFER_ADJUSTMENT_LINES_s.NEXTVAL
1158: FROM dual;
1159:
1160: CURSOR c_id_exists (l_id IN NUMBER) IS
1161: SELECT 1

Line 1230: INSERT INTO ozf_OFFER_ADJUSTMENT_LINES(

1226: EXIT WHEN l_dummy IS NULL;
1227: END LOOP;
1228: EXIT WHEN c_offer_data%NOTFOUND;
1229:
1230: INSERT INTO ozf_OFFER_ADJUSTMENT_LINES(
1231: offer_adjustment_line_id,
1232: offer_adjustment_id,
1233: list_line_id,
1234: arithmetic_operator,

Line 1354: FROM ozf_offer_adjustment_lines

1350: ,list_line_id_td
1351: ,list_header_id
1352: , arithmetic_operator
1353: , discount_end_date
1354: FROM ozf_offer_adjustment_lines
1355: WHERE offer_adjustment_id = p_offer_adjustment_id
1356: AND created_from_adjustments = 'Y';
1357:
1358: CURSOR c_rltd_line(p_list_header_id NUMBER, p_list_line_id NUMBER) IS