DBA Data[Home] [Help]

APPS.OE_OE_FORM_LINE_ADJ dependencies on OE_ORDER_LINES_ALL

Line 1155: From Oe_Order_Lines_All

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

Line 2409: From Oe_Order_Lines_All

2405: --To determine if this is an adjustment for service line of a top model line
2406: Begin
2407: Select line_id
2408: Into l_top_model_line_id
2409: From Oe_Order_Lines_All
2410: Where line_id = l_line_rec.service_reference_line_id
2411: and top_model_line_id = line_id;
2412:
2413: --this is a top model line, need to cascade the change to adjustments

Line 3472: From oe_order_lines_all a,

3468: x_line_id_tbl out nocopy Oe_Order_Adj_Pvt.Index_Tbl_Type) Is
3469:
3470: Cursor service_cur is
3471: Select b.line_id
3472: From oe_order_lines_all a,
3473: oe_order_lines_all b,
3474: oe_order_lines_all c
3475: Where a.top_model_line_id = p_top_model_line_id
3476: and a.line_id <> p_top_model_line_id

Line 3473: oe_order_lines_all b,

3469:
3470: Cursor service_cur is
3471: Select b.line_id
3472: From oe_order_lines_all a,
3473: oe_order_lines_all b,
3474: oe_order_lines_all c
3475: Where a.top_model_line_id = p_top_model_line_id
3476: and a.line_id <> p_top_model_line_id
3477: and a.line_id = b.service_reference_line_id

Line 3474: oe_order_lines_all c

3470: Cursor service_cur is
3471: Select b.line_id
3472: From oe_order_lines_all a,
3473: oe_order_lines_all b,
3474: oe_order_lines_all c
3475: Where a.top_model_line_id = p_top_model_line_id
3476: and a.line_id <> p_top_model_line_id
3477: and a.line_id = b.service_reference_line_id
3478: and c.line_id = p_service_line_id

Line 3488: From oe_order_lines_all

3484:
3485:
3486: Cursor option_cur is
3487: Select line_id
3488: From oe_order_lines_all
3489: Where top_model_line_id = p_top_model_line_id
3490: and line_id <> p_top_model_line_id;
3491:
3492: j PLS_INTEGER := 1;