Scribd Logo
Upload

Welcome to Scribd!

  • 4 views

    Factura Bo

    Uploaded by

    dantaman98

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd

    Factura Bo

    Uploaded by

    dantaman98
    4 views1 page

    Copyright

    © © All Rights Reserved

    Available Formats

    TXT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    4 views1 page

    Factura Bo

    Uploaded by

    dantaman98

    Copyright:

    © All Rights Reserved
    Download as TXT, PDF, TXT or read online from Scribd
    Download as txt, pdf, or txt
    You are on page 1of 1

    CREATE OR REPLACE PROCEDURE FACTURA(idVenda number)is

    CURSOR C_FACTURA IS
    select
    PRODUCTE.IDPRODUCTE,PRODUCTE.NOMPRODUCTE,DETALL_VENTA.QUANTITAT_COMPR_PRODUC,
    PRODUCTE.PREU
    from DETALL_VENTA,PRODUCTE
    WHERE producte_dv=idProducte
    AND venda_dv =idVenda;
    V_FACTURA C_FACTURA%rowtype;
    v_client CLIENT.NOM%type;
    v_datavenda VENDA.DATAVENDA%TYPE;
    v_descompte VENDA.DESCOMPTE%TYPE;
    v_desp_aplicat number(10,5):=0;

    BEGIN
    select client.NOM,VENDA.DATAVENDA,VENDA.DESCOMPTE
    into v_client, v_datavenda,v_descompte
    from venda, client
    where clientVenda=DNI
    and numerovenda = idVenda;
    DBMS_OUTPUT.PUT_LINE('===================================================');
    DBMS_OUTPUT.PUT_LINE('='||' '||'NUM FACTURA'||'
    '||idVenda||' '||'=');
    DBMS_OUTPUT.PUT_LINE('='||' '||'DATA DE LA VENDA'||' '||
    v_datavenda||' '||'=');
    DBMS_OUTPUT.PUT_LINE('='||' '||'DATA DE CREACI� DE FACTURA'||' '||
    SYSDATE||' '||'=');
    DBMS_OUTPUT.PUT_LINE('===================================================');
    DBMS_OUTPUT.PUT_LINE('='||' '||'DESTINATARI'||' '||'
    '||'=');
    DBMS_OUTPUT.PUT_LINE('='||' '||V_client||' '||'
    '||'=');
    DBMS_OUTPUT.PUT_LINE('='||'
    '||'------------------------------------------------=');
    DBMS_OUTPUT.PUT_LINE('='||' '||'DESCRIPCI� DE LES OPERACIONS'||'
    '||'=');
    DBMS_OUTPUT.PUT_LINE('='||' '||'CODI'||' '||'NOM'||'
    '||'PREU'||' '||'=');
    FOR V_FACTURA IN C_FACTURA LOOP
    v_desp_aplicat:=v_desp_aplicat+
    ((V_FACTURA.PREU*V_FACTURA.QUANTITAT_COMPR_PRODUC)*v_descompte)/100;
    DBMS_OUTPUT.PUT_LINE('='||' '||V_FACTURA.IDPRODUCTE||' '||
    RPAD(V_FACTURA.NOMPRODUCTE,9,' ')||' '||''||' '||RPAD(V_FACTURA.PREU,6,'
    ')||' '||'=');
    END LOOP;
    DBMS_OUTPUT.PUT_LINE('='||'
    '||'------------------------------------------------=');
    DBMS_OUTPUT.PUT_LINE('='||' '||'DESCOMPTE'||'
    '||v_descompte||'%'||' '||'=');
    DBMS_OUTPUT.PUT_LINE('='||' '||'DESCOMPTE APLICAT'||' '||
    v_desp_aplicat||'�'||' '||'=');
    DBMS_OUTPUT.PUT_LINE('='||' '||'TOTAL A PAGAR'||' '||
    TOTAL_VENDA2(IDVENDA)||'�'||' '||'=');
    DBMS_OUTPUT.PUT_LINE('===================================================');
    END;

    You might also like