Untitled

Roberto Henrique Portuguese 1 page

Content of the notes (1)

Select

Empresa.Cd_Empresa || ' - ' || Empresa.Nm_Empresa As Nm_Empresa,

Filial.Cd_Filial || ' - ' || Filial.Nm_Filial As Nm_Filial,

Filial.Nr_Cgc,

Filial.Nr_Inscricao

From

Empresa, Filial

Where

Empresa.Cd_Empresa = :piCd_Empresa And

Filial.Cd_Empresa = Empresa.Cd_Empresa And

Filial.Cd_Filial = :piCd_Filial