ERRO QUERY NO SELECT DENTRO DO FROM

[DEIASV]

Olá pessoal,

Estou rodando uma query e dentro do from tenho o seguinte select:

FROM
(select Max(fnD1.user_name) USU_HIST, PHA2.PO_HEADER_ID PO_HEADER_ID2
from po_action_history PAH2, FND_USER FND1,PO_HEADERS_ALL PHA2
where PAH2.object_id = PHA2.PO_HEADER_ID
AND FND1.EMPLOYEE_ID = PAH2.EMPLOYEE_ID
and pah2.object_type_code = 'PO'
and pah2.object_sub_type_code = PHA2.type_lookup_code
AND PAH2.SEQUENCE_NUM =
(select max(PAH2.sequeNce_num)
from po_action_history pah2
where PAH2.object_id = PHA2.PO_HEADER_ID
and pah2.object_type_code = 'PO'
and pah2.object_sub_type_code = PHA2.type_lookup_code)) RESP_ACAO


Está dando o erro de ORA-00979: not a GROUP BY expression


Se eu tirar o MAX da query ele funciona, porém preciso identificar o Max(fnD1.user_name) .

Help pleaaaase.

[gfkauer]

Tenta isso:

Selecionar tudo

Select *
  From (Select Max(fnd1.user_name) usu_hist,
               pha2.po_header_id po_header_id2
          From po_action_history pah2,
               fnd_user          fnd1,
               po_headers_all    pha2
         Where pah2.object_id = pha2.po_header_id
           And fnd1.employee_id = pah2.employee_id
           And pah2.object_type_code = 'PO'
           And pah2.object_sub_type_code = pha2.type_lookup_code
           And pah2.sequence_num =
               (Select Max(pah2.sequence_num)
                  From po_action_history pah2
                 Where pah2.object_id = pha2.po_header_id
                   And pah2.object_type_code = 'PO'
                   And pah2.object_sub_type_code = pha2.type_lookup_code)
         Group By pha2.po_header_id) resp_acao

Qualquer coisa grita.

[DEIASV]

Gente muuuuuuuuuuuitíssimo obrigadaaaaaaaa....