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_CACHE dependencies on OE_DISCOUNTS

Line 1228: FROM oe_discounts sodsc,

1224: g_hdr_discount_rec.discount_id,
1225: g_hdr_discount_rec.discount_line_id,
1226: g_hdr_discount_rec.adjustment_name,
1227: g_hdr_discount_rec.price_adjustment_id
1228: FROM oe_discounts sodsc,
1229: oe_discount_lines sodls
1230: WHERE sodls.discount_line_id = l_discount_line_id
1231: AND sodls.discount_id = sodsc.discount_id;
1232:

Line 1247: FROM oe_discounts sodsc

1243: g_hdr_discount_rec.discount_id,
1244: g_hdr_discount_rec.discount_line_id,
1245: g_hdr_discount_rec.adjustment_name,
1246: g_hdr_discount_rec.price_adjustment_id
1247: FROM oe_discounts sodsc
1248: WHERE l_discount_id = sodsc.discount_id;
1249:
1250: END IF;
1251:

Line 1339: FROM oe_discounts sodsc,

1335: g_line_discount_rec.discount_id,
1336: g_line_discount_rec.discount_line_id,
1337: g_line_discount_rec.adjustment_name,
1338: g_line_discount_rec.price_adjustment_id
1339: FROM oe_discounts sodsc,
1340: oe_discount_lines sodls,
1341: oe_price_break_lines sopbl,
1342: oe_order_lines oeorln
1343: WHERE sodls.discount_line_id = l_discount_line_id

Line 1362: FROM oe_discounts sodsc,

1358: g_line_discount_rec.discount_id,
1359: g_line_discount_rec.discount_line_id,
1360: g_line_discount_rec.adjustment_name,
1361: g_line_discount_rec.price_adjustment_id
1362: FROM oe_discounts sodsc,
1363: oe_order_lines oeorln
1364: WHERE sodsc.discount_id = l_discount_id
1365: AND oeorln.line_id = l_line_id;
1366: