APPS.OE_UPG_SO dependencies on OE_UPGRADE_LOG_V

Line 3740: (select old_line_id from oe_upgrade_log_v

3736: and parent_line_id is null -- To filter out option lines
3737: and line_id in
3738: (select shipment_schedule_line_id from so_lines_all
3739: where line_id in
3740: (select old_line_id from oe_upgrade_log_v
3741: where new_line_id in
3742: (select line_id from oe_order_lines_all
3743: where line_set_id is null)))
3744: order by header_id, line_id;

Line 3773: from oe_upgrade_log_v lg, oe_order_lines_all ln

3769: and parent_line_id is null -- To filter out options (included on Leena's instn.)
3770: and parent_line_id is null -- To filter out options (included on Leena's instn.)
3771: and sla.line_id in
3772: (select lg.old_line_id
3773: from oe_upgrade_log_v lg, oe_order_lines_all ln
3774: where lg.new_line_id = ln.line_id
3775: and ln.item_type_code not in ('INCLUDED','CONFIG')
3776: group by lg.old_line_id
3777: having count(*) > 1);

Line 3999: oe_upgrade_log_v oul1,

3995: for c2 in c1 loop
3996: begin
3997: select oul2.new_line_id into v_new_line_id
3998: from
3999: oe_upgrade_log_v oul1,
4000: oe_upgrade_log_v oul2,
4001: so_lines_all sla1,
4002: so_lines_all sla2
4003: where oul1.new_line_id = c2.line_id

Line 4000: oe_upgrade_log_v oul2,

3996: begin
3997: select oul2.new_line_id into v_new_line_id
3998: from
3999: oe_upgrade_log_v oul1,
4000: oe_upgrade_log_v oul2,
4001: so_lines_all sla1,
4002: so_lines_all sla2
4003: where oul1.new_line_id = c2.line_id
4004: and oul1.old_line_id = sla1.line_id

Line 4872: select max(old_line_id) into G_OLD_LINE_ID from oe_upgrade_log_v

4868: /* bring old_line_id from log table using the L_Line_id as the new_line_id */
4869:
4870: G_OLD_LINE_ID := 0;
4871: begin
4872: select max(old_line_id) into G_OLD_LINE_ID from oe_upgrade_log_v
4873: where new_line_id = p_orig_line_id;
4874: exception
4875: when others then
4876: G_OLD_LINE_ID := 0;