APPS.OE_ORDER_COPY_UTIL dependencies on OE_ORDER_LINES_HISTORY

Line 5297: oe_order_lines_history l

5293: 'Y',
5294: l.top_model_line_id,
5295: l.item_type_code
5296: FROM
5297: oe_order_lines_history l
5298: WHERE l.line_id = l_line_id(i)
5299: --and l.version_number = NVL(p_version_number,l.version_number) -- bug 7443507
5300: and l.version_number = p_version_number -- bug 7443507
5301: and l.phase_change_flag = 'Y';

Line 5334: oe_order_lines_history l

5330: 'Y',
5331: l.top_model_line_id,
5332: l.item_type_code
5333: FROM
5334: oe_order_lines_history l
5335: WHERE l.line_id = l_line_id(i)
5336: and l.phase_change_flag = 'Y';
5337:
5338: -- bug 7443507 new code ends.

Line 5382: oe_order_lines_history l,

5378: 'Y',
5379: l.top_model_line_id,
5380: l.item_type_code
5381: FROM
5382: oe_order_lines_history l,
5383: oe_copy_line_sort_tmp c
5384: WHERE c.line_id = c.top_model_line_id
5385: and l.top_model_line_id = c.line_id
5386: --and l.line_id <> l.top_model_line_id -- bug 7443507

Line 5420: oe_order_lines_history l,

5416: 'Y',
5417: l.top_model_line_id,
5418: l.item_type_code
5419: FROM
5420: oe_order_lines_history l,
5421: oe_copy_line_sort_tmp c
5422: WHERE c.line_id = c.top_model_line_id
5423: and l.top_model_line_id = c.line_id
5424: and l.item_type_code not in ('CONFIG','INCLUDED','MODEL','KIT')

Line 5479: oe_order_lines_history l

5475: l.service_number,
5476: l.top_model_line_id,
5477: l.item_type_code
5478: FROM
5479: oe_order_lines_history l
5480: WHERE l.line_id = l_line_id(i)
5481: --and l.version_number = NVL(p_version_number,-1) --bug 7443507
5482: and l.version_number = p_version_number -- bug 7443507
5483: and l.version_flag = 'Y';

Line 5586: oe_order_lines_history l,

5582: l.service_number,
5583: l.top_model_line_id,
5584: l.item_type_code
5585: FROM
5586: oe_order_lines_history l,
5587: oe_copy_line_sort_tmp c
5588: WHERE c.line_id = c.top_model_line_id
5589: and l.top_model_line_id = c.line_id
5590: --and l.line_id <> l.top_model_line_id -- bug 7443507