1
SELECT o.ad_client_id,
2
o.ad_org_id,
3
o.isactive,
4
o.created,
5
o.createdby,
6
o.updated,
7
o.updatedby,
8
owt.ad_language,
9
o.pp_order_id,
10
o.docstatus,
11
o.c_doctype_id,
12
oi.c_location_id AS org_location_id,
13
oi.taxid,
14
o.m_warehouse_id,
15
wh.c_location_id AS warehouse_location_id,
16
dt.printname AS documenttype,
17
dt.documentnote AS documenttypenote,
18
o.planner_id,
19
u.name AS salesrep_name,
20
o.datestart,
21
o.datestartschedule,
22
o.floatafter,
23
o.floatbefored,
24
o.line,
25
o.lot,
26
o.serno,
27
o.c_uom_id,
28
o.pp_product_bom_id,
29
o.assay,
30
o.c_orderline_id,
31
o.priorityrule,
32
o.qtybatchsize,
33
o.qtybatchs,
34
o.qtydelivered,
35
o.qtyentered,
36
o.qtyordered,
37
o.dateconfirm,
38
o.datedelivered,
39
o.datefinish,
40
o.datefinishschedule,
41
o.dateordered,
42
o.datepromised,
43
o.qtyreject,
44
o.qtyreserved,
45
o.qtyscrap,
46
o.s_resource_id,
47
o.c_campaign_id,
48
o.c_project_id,
49
o.c_activity_id,
50
owt.name,
51
owt.description,
52
owt.help,
53
ow.author,
54
ow.cost,
55
ow.documentno,
56
ow.duration,
57
ow.durationunit,
58
ow.version,
59
ow.validfrom,
60
ow.validto,
61
ow.movingtime,
62
ow.overlapunits,
63
ow.ad_workflow_id,
64
ow.publishstatus,
65
ow.queuingtime,
66
ow.setuptime,
67
ow.unitscycles,
68
ow.waitingtime,
69
ow.workflowtype,
70
ow.workingtime,
71
ow.yield,
72
COALESCE(oi.logo_id, ci.logo_id) AS logo_id
73
FROM (((((((pp_order o
74
JOIN pp_order_workflow ow ON ((ow.pp_order_id = o.pp_order_id)))
75
JOIN pp_order_workflow_trl owt ON ((owt.pp_order_workflow_id = ow.pp_order_workflow_id)))
76
JOIN c_doctype dt ON ((o.c_doctype_id = dt.c_doctype_id)))
77
JOIN m_warehouse wh ON ((o.m_warehouse_id = wh.m_warehouse_id)))
78
JOIN ad_orginfo oi ON ((o.ad_org_id = oi.ad_org_id)))
79
JOIN ad_clientinfo ci ON ((o.ad_client_id = ci.ad_client_id)))
80
LEFT JOIN ad_user u ON ((o.planner_id = u.ad_user_id)));