[Home] [Help]
511: sla.link_to_line_id,
512: nvl(sld.component_sequence_id,sla.component_sequence_id) component_sequence_id,
513: nvl(sld.component_code,sla.component_code) component_code,
514: decode(sla.item_type_code,
515: 'STANDARD', decode(sla.option_flag,
516: 'Y','OPTION',
517: sla.item_type_code),
518: 'MODEL', decode(sla.parent_line_id,
519: NULL,'MODEL',
539: NULL, decode(ato_flag,
540: 'Y', sla.line_id,
541: sla.ato_line_id),
542: sla.ato_line_id),
543: 'STANDARD', decode(sla.ato_line_id,
544: NULL, decode(ato_flag,
545: 'Y', sla.line_id,
546: sla.ato_line_id),
547: sla.ato_line_id),
554: sla.line_type_code,
555: sla.return_reference_id,
556: nvl(sla.open_flag,'N') open_flag,
557: sla.ship_model_complete_flag,
558: sla.standard_component_freeze_date,
559: decode(sla.s1,1,'Y','N') booked_flag,
560: decode(nvl(sld.picking_line_id,0),0,'N','Y') shipping_interfaced_flag,
561: decode(sla.s4,6,'Y',NULL) fulfilled_flag,
562: decode(sla.s5,9,'YES',8,'NOT_ELIGIBLE',24,'NOT_ELIGIBLE',NULL) invoice_interface_status_code,
882: g_line_rec.line_type_code :=mol.line_type_code;
883: g_line_rec.return_reference_id :=mol.return_reference_id;
884: g_line_rec.open_flag :=mol.open_flag;
885: g_line_rec.ship_model_complete_flag :=mol.ship_model_complete_flag;
886: g_line_rec.standard_component_freeze_date :=mol.standard_component_freeze_date;
887:
888: G_ERROR_LOCATION := 7023;
889:
890: g_line_rec.booked_flag :=mol.booked_flag;
2003: g_line_rec.ato_line_id, /* ATO_LINE_ID */
2004: null, /* auto_selected_quantity, */
2005: null, /* component_number, */
2006: null, /* earliest_acceptable_date, */
2007: g_line_rec.standard_component_freeze_date, /* explosion_date, */
2008: g_line_rec.latest_acceptable_date, /* latest_acceptable_date, */
2009: null, /* model_group_number, */
2010: null, /* schedule_arrival_date, */
2011: g_line_rec.ship_model_complete_flag, /* ship_model_complete_flag, */
3371: g_line_rec.ato_line_id, /* ATO_LINE_ID */
3372: null, /* auto_selected_quantity, */
3373: null, /* component_number, */
3374: null, /* earliest_acceptable_date, */
3375: g_line_rec.standard_component_freeze_date, /* explosion_date, */
3376: g_line_rec.latest_acceptable_date, /* latest_acceptable_date, */
3377: null, /* model_group_number, */
3378: null, /* schedule_arrival_date, */
3379: g_line_rec.ship_model_complete_flag, /* ship_model_complete_flag, */
3730: unit_code
3731: from
3732: so_lines_all
3733: where line_type_code = 'PARENT'
3734: and item_type_code in ('KIT','MODEL','STANDARD')
3735: and parent_line_id is null -- To filter out option lines
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
3751: where line_id in
3752: (select new_line_id from oe_upgrade_log oul, so_lines_all sla
3753: where oul.old_line_id = sla.line_id
3754: and sla.shipment_schedule_line_id = v_line_id)
3755: and item_type_code in ('KIT','MODEL','STANDARD')
3756: order by line_id;
3757:
3758: cursor c5 is
3759: select
3764: unit_code
3765: from
3766: so_lines_all sla
3767: where sla.line_type_code = 'REGULAR'
3768: AND item_type_code in ('KIT','MODEL','STANDARD')
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
3949: when no_data_found then
3950: null;
3951: end ;
3952: IF v_item_type_code = 'MODEL' OR
3953: v_item_type_code = 'STANDARD' OR
3954: v_item_type_code = 'KIT' THEN
3955:
3956: v_shipment_number := v_shipment_number + 1;
3957: