mht_brerp10.adempiere

Parameters

Name	Type	Mode
client_id	numeric	IN
org_id	numeric	IN
taxname_id	numeric	IN
taxstatus	character varying	IN
cfop_id	numeric	IN
tpoperation	character varying	IN

Definition

DECLARE
     COF_C_Determination_Group_ID     numeric;
    DateNow        TIMESTAMP = getDate();
BEGIN
    BEGIN
        SELECT
            taxCL.COF_C_Determination_Group_ID
        INTO STRICT COF_C_Determination_Group_ID
        FROM
            COF_C_TaxClassification taxC
        LEFT JOIN COF_C_TaxClassificationLine taxCL ON (taxC.COF_C_TaxClassification_ID=taxCL.COF_C_TaxClassification_ID)

WHERE
            CASE WHEN TaxName_ID <=0 THEN taxC.LBR_TaxName_ID IS NULL AND taxC.cof_isSimpleNational='Y' ELSE taxC.LBR_TaxName_ID=TaxName_ID AND taxC.cof_isSimpleNational='N'END AND taxC.IsActive='Y' AND taxCL.IsActive='Y' AND taxC.AD_Client_ID IN (0, CLIENT_ID) AND taxC.AD_Org_ID IN (0,ORG_ID) AND taxCL.AD_Client_ID IN (0,CLIENT_ID) AND taxCL.AD_Org_ID IN (0,ORG_ID)
            AND taxC.ValidFrom::DATE <= DateNow AND taxC.ValidTo::DATE >= DateNow
            AND taxCL.COF_OperationType = TpOperation
            AND (taxCL.LBR_TaxStatus_ID IS NULL OR taxCL.LBR_TaxStatus_ID IN (SELECT LBR_TaxStatus_ID FROM LBR_TaxStatus WHERE LBR_TaxName_ID=TaxName_ID AND LTRIM(RTRIM(Name)) = LTRIM(RTRIM(TaxStatus)) AND IsActive='Y'))
            AND (taxCL.LBR_CFOP_ID = CFOP_ID OR taxCL.LBR_CFOP_ID IS NULL)

ORDER BY taxCL.AD_Client_ID, taxCL.AD_Org_ID DESC, taxCL.LBR_CFOP_ID DESC
        LIMIT 1;
    EXCEPTION
        WHEN NO_DATA_FOUND THEN
            COF_C_Determination_Group_ID := 0;
    END;
    RETURN COF_C_Determination_Group_ID;
END;

cof_get_determination_group(numeric, numeric, numeric, character varying, numeric, character varying)

Parameters

Definition