1
SELECT COALESCE(l.ad_client_id, i.ad_client_id) AS ad_client_id,
2
COALESCE(l.ad_org_id, i.ad_org_id) AS ad_org_id,
3
COALESCE(l.isactive, i.isactive) AS isactive,
4
COALESCE(l.created, i.created) AS created,
5
COALESCE(l.createdby, i.createdby) AS createdby,
6
COALESCE(l.updated, i.updated) AS updated,
7
COALESCE(l.updatedby, i.updatedby) AS updatedby,
8
COALESCE(l.c_project_id, i.c_project_id) AS c_project_id,
9
COALESCE(l.m_product_id, i.m_product_id) AS m_product_id,
10
l.c_projectline_id,
11
l.line,
12
l.description,
13
l.plannedqty,
14
l.plannedprice,
15
l.plannedamt,
16
l.plannedmarginamt,
17
l.committedqty,
18
i.c_projectissue_id,
19
i.m_locator_id,
20
i.movementqty,
21
i.movementdate,
22
i.line AS issueline,
23
i.description AS issuedescription,
24
i.m_inoutline_id,
25
i.s_timeexpenseline_id,
26
fa.c_acctschema_id,
27
fa.account_id,
28
fa.amtsourcedr,
29
fa.amtsourcecr,
30
fa.amtacctdr,
31
fa.amtacctcr,
32
((l.plannedamt - fa.amtsourcedr) + fa.amtsourcecr) AS linemargin
33
FROM ((c_projectline l
34
FULL JOIN c_projectissue i ON (((i.c_project_id = l.c_project_id) AND (i.c_projectissue_id = l.c_projectissue_id))))
35
LEFT JOIN fact_acct fa ON (((fa.ad_table_id = (623)::numeric) AND (fa.record_id = i.c_projectissue_id) AND (fa.m_locator_id IS NULL))));