1
SELECT tep.ad_org_id,
2
tep.ad_client_id,
3
tep.cof_identificadortransacao,
4
tep.m_product_id,
5
p.cof_producttype_id,
6
p.cof_productclass_id,
7
p.cof_productgroup_id,
8
tep.movementdate,
9
tep.oldqty AS quantidade_antiga,
10
tep.qty,
11
ep.qty AS quantidade_atual,
12
tep.lbr_docfiscal_line_id,
13
tep.m_productionline_id,
14
tep.cof_ajusteestoqueprvstline_id,
15
ep.cumulatedamt AS cof_cumulatedcostamt,
16
ep.currentcostprice,
17
tep.amt,
18
tep.cumulatedamt,
19
COALESCE(df.documentno, pr.documentno, aj.documentno) AS documentno,
20
df.ide_dhemi,
21
df.dateacct,
22
dfl.det_prod_cfop,
23
dfl.lbr_cfop_id
24
FROM ((((((((cof_trxestoqueprevisto tep
25
LEFT JOIN cof_estoqueprevisto ep ON (((ep.ad_org_id = tep.ad_org_id) AND (ep.m_product_id = tep.m_product_id))))
26
LEFT JOIN lbr_docfiscal_line dfl ON ((dfl.lbr_docfiscal_line_id = tep.lbr_docfiscal_line_id)))
27
LEFT JOIN lbr_docfiscal df ON ((df.lbr_docfiscal_id = dfl.lbr_docfiscal_id)))
28
LEFT JOIN m_product p ON ((p.m_product_id = tep.m_product_id)))
29
LEFT JOIN cof_ajusteestoqueprvstline ajl ON ((ajl.cof_ajusteestoqueprvstline_id = tep.cof_ajusteestoqueprvstline_id)))
30
LEFT JOIN cof_ajusteestoqueprevisto aj ON ((aj.cof_ajusteestoqueprevisto_id = ajl.cof_ajusteestoqueprevisto_id)))
31
LEFT JOIN m_productionline pl ON ((pl.m_productionline_id = tep.m_productionline_id)))
32
LEFT JOIN m_production pr ON ((pr.m_production_id = pl.m_production_id)));