APPS.OE_ORDER_COPY_UTIL dependencies on OE_ORDER_LINES_HISTORY

Line 5468: oe_order_lines_history l

5464: 'Y',
5465: l.top_model_line_id,
5466: l.item_type_code
5467: FROM
5468: oe_order_lines_history l
5469: WHERE l.line_id = l_line_id(i)
5470: --and l.version_number = NVL(p_version_number,l.version_number) -- bug 7443507
5471: and l.version_number = p_version_number -- bug 7443507
5472: and l.phase_change_flag = 'Y';

Line 5505: oe_order_lines_history l

5501: 'Y',
5502: l.top_model_line_id,
5503: l.item_type_code
5504: FROM
5505: oe_order_lines_history l
5506: WHERE l.line_id = l_line_id(i)
5507: and l.phase_change_flag = 'Y';
5508:
5509: -- bug 7443507 new code ends.

Line 5553: oe_order_lines_history l,

5549: 'Y',
5550: l.top_model_line_id,
5551: l.item_type_code
5552: FROM
5553: oe_order_lines_history l,
5554: oe_copy_line_sort_tmp c
5555: WHERE c.line_id = c.top_model_line_id
5556: and l.top_model_line_id = c.line_id
5557: --and l.line_id <> l.top_model_line_id -- bug 7443507

Line 5591: oe_order_lines_history l,

5587: 'Y',
5588: l.top_model_line_id,
5589: l.item_type_code
5590: FROM
5591: oe_order_lines_history l,
5592: oe_copy_line_sort_tmp c
5593: WHERE c.line_id = c.top_model_line_id
5594: and l.top_model_line_id = c.line_id
5595: and l.item_type_code not in ('CONFIG','INCLUDED','MODEL','KIT')

Line 5650: oe_order_lines_history l

5646: l.service_number,
5647: l.top_model_line_id,
5648: l.item_type_code
5649: FROM
5650: oe_order_lines_history l
5651: WHERE l.line_id = l_line_id(i)
5652: --and l.version_number = NVL(p_version_number,-1) --bug 7443507
5653: and l.version_number = p_version_number -- bug 7443507
5654: and l.version_flag = 'Y';

Line 5757: oe_order_lines_history l,

5753: l.service_number,
5754: l.top_model_line_id,
5755: l.item_type_code
5756: FROM
5757: oe_order_lines_history l,
5758: oe_copy_line_sort_tmp c
5759: WHERE c.line_id = c.top_model_line_id
5760: and l.top_model_line_id = c.line_id
5761: --and l.line_id <> l.top_model_line_id -- bug 7443507