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_OE_FORM_LINE_ADJ dependencies on OE_ORDER_LINES_ALL

Line 1153: From Oe_Order_Lines_All

1149: --To determine if this is an adjustment for service line of a top model line
1150: Begin
1151: Select line_id
1152: Into l_top_model_line_id
1153: From Oe_Order_Lines_All
1154: Where line_id = l_line_rec.service_reference_line_id
1155: and top_model_line_id = line_id;
1156:
1157: --This is a service line of a top model line, need to cascade the change to adjustments

Line 2392: From Oe_Order_Lines_All

2388: --To determine if this is an adjustment for service line of a top model line
2389: Begin
2390: Select line_id
2391: Into l_top_model_line_id
2392: From Oe_Order_Lines_All
2393: Where line_id = l_line_rec.service_reference_line_id
2394: and top_model_line_id = line_id;
2395:
2396: --this is a top model line, need to cascade the change to adjustments

Line 3442: From oe_order_lines_all a,

3438: x_line_id_tbl out nocopy Oe_Order_Adj_Pvt.Index_Tbl_Type) Is
3439:
3440: Cursor service_cur is
3441: Select b.line_id
3442: From oe_order_lines_all a,
3443: oe_order_lines_all b,
3444: oe_order_lines_all c
3445: Where a.top_model_line_id = p_top_model_line_id
3446: and a.line_id <> p_top_model_line_id

Line 3443: oe_order_lines_all b,

3439:
3440: Cursor service_cur is
3441: Select b.line_id
3442: From oe_order_lines_all a,
3443: oe_order_lines_all b,
3444: oe_order_lines_all c
3445: Where a.top_model_line_id = p_top_model_line_id
3446: and a.line_id <> p_top_model_line_id
3447: and a.line_id = b.service_reference_line_id

Line 3444: oe_order_lines_all c

3440: Cursor service_cur is
3441: Select b.line_id
3442: From oe_order_lines_all a,
3443: oe_order_lines_all b,
3444: oe_order_lines_all c
3445: Where a.top_model_line_id = p_top_model_line_id
3446: and a.line_id <> p_top_model_line_id
3447: and a.line_id = b.service_reference_line_id
3448: and c.line_id = p_service_line_id

Line 3458: From oe_order_lines_all

3454:
3455:
3456: Cursor option_cur is
3457: Select line_id
3458: From oe_order_lines_all
3459: Where top_model_line_id = p_top_model_line_id
3460: and line_id <> p_top_model_line_id;
3461:
3462: j PLS_INTEGER := 1;