This is an archive of the Maximo Yahoo Community. The content of this pages may be a sometimes obsolete so please check post dates.
Thanks to the community owner Christopher Wanko for providing the content.
Hello everyone,
How can I go about and see who approved a PO?
Our Managers have to approve the PO's but where can I in there name?
I'm 'smh'
Maximo 6.2.1
SQL 2005
WEBLOGIC
thx,
mrggutz
Try the POSTATUS table CHANGEBY field for the PO and STATUS='APPR'
On Thu, Dec 1, 2011 at 10:53 AM, George <ggutierrez@pasadenarefining.com>wrote:
> **
>
>
> Hello everyone,
> How can I go about and see who approved a PO?
> Our Managers have to approve the PO's but where can I in there name?
>
> I'm 'smh'
>
> Maximo 6.2.1
> SQL 2005
> WEBLOGIC
>
> thx,
> mrggutz
>
>
>
Ok thanks I will try that.
Thank You,
George Gutierrez Jr.
Maximo Administration
Pasadena Refining Systems
713.920.3908 Direct
832.473.5330 Cell
U1O2 - Chave
Chris Lawless
<lawlessc@gmail.com>
Sent by: To
MAXIMO@yahoogroups.c MAXIMO@yahoogroups.com
om cc
Subject
12/01/2011 01:05 PM Re: [MAXIMO List] PO Approver
Please respond to
MAXIMO@yahoogroups.c
om
Try the POSTATUS table CHANGEBY field for the PO and STATUS='APPR'
On Thu, Dec 1, 2011 at 10:53 AM, George
<ggutierrez@pasadenarefining.com>wrote:
> **
>
>
> Hello everyone,
> How can I go about and see who approved a PO?
> Our Managers have to approve the PO's but where can I in there name?
>
> I'm 'smh'
>
> Maximo 6.2.1
> SQL 2005
> WEBLOGIC
>
> thx,
> mrggutz
>
>
>
------------------------------------
Email addresses you might need:
Posting: MAXIMO@yahoogroups.com
Join : MAXIMO-subscribe@yahoogroups.com
Leave : MAXIMO-unsubscribe@yahoogroups.com
Cry : MAXIMO-owner@yahoogroups.com
Group : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
This what I'm trying to use. It works but I don't see the managers name, it
has some names but they wouldnt be the approvers....hmm
I'm sure it's something small and something I didn't do correctly.
select PO.NBJJUSTTYPE as NBJ,po.ponum, po.description,vendor,companies.name
,orderdate,purchaseagent,po.originalpovalue,po.lastpovalue,totalcost,po.
status,po.changeby,po.changedate,po.priority,po.receipts,po.poid,postatus.
changeby as approver
from po LEFT OUTER JOIN
companies ON po.vendor = companies.company
LEFT OUTER JOIN
postatus ON po.ponum = postatus.ponum and postatus.status = 'APPR'
where DATEPART(mm,PO.ORDERDATE) = 10--:Mnth
and DATEPART(yyyy, PO.ORDERDATE) = 2011--:Year
and po.status not in ('CAN')
Thank You,
George Gutierrez Jr.
Maximo Administration
Pasadena Refining Systems
713.920.3908 Direct
832.473.5330 Cell
U1O2 - Chave
ggutierrez@pasadenar
efining.com
Sent by: To
MAXIMO@yahoogroups.c MAXIMO@yahoogroups.com
om cc
Subject
12/01/2011 01:15 PM Re: [MAXIMO List] PO Approver
Please respond to
MAXIMO@yahoogroups.c
om
Ok thanks I will try that.
Thank You,
George Gutierrez Jr.
Maximo Administration
Pasadena Refining Systems
713.920.3908 Direct
832.473.5330 Cell
U1O2 - Chave
Chris Lawless
<lawlessc@gmail.com>
Sent by: To
MAXIMO@yahoogroups.c MAXIMO@yahoogroups.com
om cc
Subject
12/01/2011 01:05 PM Re: [MAXIMO List] PO Approver
Please respond to
MAXIMO@yahoogroups.c
om
Try the POSTATUS table CHANGEBY field for the PO and STATUS='APPR'
On Thu, Dec 1, 2011 at 10:53 AM, George
<ggutierrez@pasadenarefining.com>wrote:
> **
>
>
> Hello everyone,
> How can I go about and see who approved a PO?
> Our Managers have to approve the PO's but where can I in there name?
>
> I'm 'smh'
>
> Maximo 6.2.1
> SQL 2005
> WEBLOGIC
>
> thx,
> mrggutz
>
>
>
------------------------------------
Email addresses you might need:
Posting: MAXIMO@yahoogroups.com
Join : MAXIMO-subscribe@yahoogroups.com
Leave : MAXIMO-unsubscribe@yahoogroups.com
Cry : MAXIMO-owner@yahoogroups.com
Group : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
Hi,
Try this to get the names - you are only selecting the codes.
select
po.NBJJUSTTYPE as NBJ,
po.ponum,
po.description,
po.vendor,
companies.name as vendorname,
po.orderdate,
po.purchaseagent as buyercode,
person2.displayname as buyername,
po.originalpovalue,
po.lastpovalue,
po.totalcost,
po.status,
po.changeby,
po.changedate,
po.priority,
po.receipts,
po.poid,
postatus.changeby as approvercode,
person.displayname as approvername
from po
LEFT OUTER JOIN companies
ON po.vendor = companies.company
and po.orgid = companies.orgid
LEFT OUTER JOIN postatus
ON po.ponum = postatus.ponum
and po.orgid = postatus.orgid
and postatus.status = 'APPR'
LEFT OUTER JOIN MAXUSER
ON MAXUSER.USERID = POSTATUS.CHANGEBY
LEFT OUTER JOIN PERSON
ON PERSON.PERSONID = MAXUSER.PERSONID
LEFT OUTER JOIN PERSON PERSON2
ON PERSON2.PERSONID = PO.purchaseagent
where DATEPART(mm,PO.ORDERDATE) = 10--:Mnth
and DATEPART(yyyy, PO.ORDERDATE) = 2011--:Year
and po.status not in ('CAN')
--- In MAXIMO@yahoogroups.com, ggutierrez@... wrote:
>
> This what I'm trying to use. It works but I don't see the managers name, it
> has some names but they wouldnt be the approvers....hmm
> I'm sure it's something small and something I didn't do correctly.
>
> select PO.NBJJUSTTYPE as NBJ,po.ponum, po.description,vendor,companies.name
> ,orderdate,purchaseagent,po.originalpovalue,po.lastpovalue,totalcost,po.
> status,po.changeby,po.changedate,po.priority,po.receipts,po.poid,postatus.
> changeby as approver
> from po LEFT OUTER JOIN
> companies ON po.vendor = companies.company
> LEFT OUTER JOIN
> postatus ON po.ponum = postatus.ponum and postatus.status = 'APPR'
> where DATEPART(mm,PO.ORDERDATE) = 10--:Mnth
> and DATEPART(yyyy, PO.ORDERDATE) = 2011--:Year
> and po.status not in ('CAN')
>
>
>
> Thank You,
>
> George Gutierrez Jr.
> Maximo Administration
> Pasadena Refining Systems
> 713.920.3908 Direct
> 832.473.5330 Cell
> U1O2 - Chave
>
>
>
> ggutierrez@pasadenar
> efining.com
> Sent by: To
> MAXIMO@... MAXIMO@yahoogroups.com
> om cc
>
> Subject
> 12/01/2011 01:15 PM Re: [MAXIMO List] PO Approver
>
>
> Please respond to
> MAXIMO@...
> om
>
>
>
>
>
>
>
>
>
> Ok thanks I will try that.
>
> Thank You,
>
> George Gutierrez Jr.
> Maximo Administration
> Pasadena Refining Systems
> 713.920.3908 Direct
> 832.473.5330 Cell
> U1O2 - Chave
>
> Chris Lawless
> <lawlessc@...>
> Sent by: To
> MAXIMO@... MAXIMO@yahoogroups.com
> om cc
>
> Subject
> 12/01/2011 01:05 PM Re: [MAXIMO List] PO Approver
>
>
> Please respond to
> MAXIMO@...
> om
>
>
>
> Try the POSTATUS table CHANGEBY field for the PO and STATUS='APPR'
>
> On Thu, Dec 1, 2011 at 10:53 AM, George
> <ggutierrez@...>wrote:
>
> > **
> >
> >
> > Hello everyone,
> > How can I go about and see who approved a PO?
> > Our Managers have to approve the PO's but where can I in there name?
> >
> > I'm 'smh'
> >
> > Maximo 6.2.1
> > SQL 2005
> > WEBLOGIC
> >
> > thx,
> > mrggutz
> >
> >
> >
>
>
>
> ------------------------------------
>
> Email addresses you might need:
> Posting: MAXIMO@yahoogroups.com
> Join : MAXIMO-subscribe@yahoogroups.com
> Leave : MAXIMO-unsubscribe@yahoogroups.com
> Cry : MAXIMO-owner@yahoogroups.com
> Group : http://groups.yahoo.com/group/MAXIMOYahoo! Groups Links
>