--Order 20014824

insert into invoicelinesubtype i
      (i.invoicelinesubtype_id,
       subtype,
       invoicelinetype_id,
       factorydescription,
       systemuser_id,
       timestamp)
      select seq_invoicelinesubtype.nextval,
            39,
             9,
             'Loss Charge Garments – Decrease Max Inventory',
             getminsystemuser(),
             sysdate
        from dual;
commit;
        
insert into invoicelinesubtype_desc
      (invoicelinesubtype_id,
       language_id,
       description,
       systemuser_id,
       timestamp)
      select i.invoicelinesubtype_id,
             l.language_id,
             i.factorydescription,
             1,
             sysdate
        from invoicelinesubtype i, languages l
       where l.translatedescription = 'Y' and i.invoicelinetype_id = 9 and i.subtype = 39;
commit; 
