Eu tenho a query abaixo e o seguinte problema:
Estou com proble na amarração da query esta retornando linha duplicadas e eu não acho o problema. alguém pode me ajudar ?
A query é essa.
select ri.operation_id "Nº Rec"
,ri.invoice_num "Nota Fiscal"
,ri.creation_date "Emissão"
,ri.series "Serie"
,ril.icms_amount "Valor do ICMS"
,ril.ipi_base_amount "Valor do IPI"
,reo.creation_date "Dt Rec"
,reo.status "Status Nota"
,pv.vendor_name "Fornecedor"
,at.name "Condição de Pagto"
,pha.segment1 "Numero OC"
,msib.segment1 "Cod Item"
,msit.description "Descrição"
,rfo.cfo_code "CFO"
,ril.uom "UN Medida"
,ril.quantity "Qtde"
,ril.unit_price "Preço UN"
,ril.total_amount "Total Nota"
,ril.icms_tax "Alicota ICMS"
from apps.rec_invoices ri
,apps.rec_invoice_lines ril
,apps.rec_entry_operations reo
,apps.po_vendors pv
,apps.ap_terms at
,apps.rec_fiscal_entities_all rfea
,apps.po_vendor_sites_all pvsa
,apps.po_headers_all pha
,apps.po_lines_all pla
,apps.po_line_locations_all plla
,apps.mtl_system_items_b msib
,apps.mtl_system_items_tl msit
,apps.rec_fiscal_operations rfo
where ri.invoice_id = ril.invoice_id
and ri.organization_id = reo.organization_id
and ri.operation_id = reo.operation_id
and ri.entity_id = rfea.entity_id
and ri.terms_id = at.term_id
and pvsa.vendor_site_id = rfea.vendor_site_id
and pvsa.vendor_id = pv.vendor_id
and plla.line_location_id = ril.line_location_id
and plla.po_header_id = pha.po_header_id
and pha.po_header_id = pla.po_header_id
-- and ri.operation_id = 100000
-- and ri.organization_id = 56
and msib.inventory_item_id = ril.item_id
and msib.organization_id = ri.organization_id
and msit.organization_id = msib.organization_id
and msit.inventory_item_id = msib.inventory_item_id
and msit.language = 'PTB'
and rfo.cfo_id = ril.cfo_id
and ri.creation_date between to_date('01/01/2005','dd/mm/yyyy')
and to_date('10/01/2005','dd/mm/yyyy')
order by ri.operation_id;