[Home] [Help]
5280:
5281: cursor log_product_lines (p_service_parent_line_id IN NUMBER) IS
5282:
5283: select old_line_id, new_line_id from
5284: oe_upgrade_log_v where
5285: old_line_id = p_service_parent_line_id
5286: and old_line_id <> new_line_id
5287: order by new_line_id;
5288:
5288:
5289: cursor log_service_lines (p_line_id IN NUMBER) IS
5290:
5291: select old_line_id, new_line_id from
5292: oe_upgrade_log_v where
5293: old_line_id = p_line_id
5294: and old_line_id <> new_line_id
5295: order by new_line_id;
5296:
5912: and parent_line_id is null -- To filter out options (included on Leena's instn.)
5913: -- and sla.line_id in
5914: and exists
5915: (select /*+ INDEX(ln OE_ORDER_LINES_N1) */lg.old_line_id
5916: from oe_upgrade_log_v lg, oe_order_lines_all ln
5917: where ln.header_id = sla.header_id
5918: and lg.old_line_id = sla.line_id
5919: and lg.new_line_id = ln.line_id
5920: and ln.item_type_code not in ('INCLUDED','CONFIG')
7139: /* bring old_line_id from log table using the L_Line_id as the new_line_id */
7140:
7141: G_OLD_LINE_ID := 0;
7142: begin
7143: select max(old_line_id) into G_OLD_LINE_ID from oe_upgrade_log_v
7144: where new_line_id = p_orig_line_id;
7145: exception
7146: when others then
7147: G_OLD_LINE_ID := 0;
8842:
8843: cursor log_product_lines (p_service_parent_line_id IN NUMBER) IS
8844:
8845: select old_line_id, new_line_id from
8846: oe_upgrade_log_v where
8847: old_line_id = p_service_parent_line_id
8848: and old_line_id <> new_line_id
8849: order by new_line_id;
8850:
8850:
8851: cursor log_service_lines (p_line_id IN NUMBER) IS
8852:
8853: select old_line_id, new_line_id from
8854: oe_upgrade_log_v where
8855: old_line_id = p_line_id
8856: and old_line_id <> new_line_id
8857: order by new_line_id;
8858: