POI_ALLREQ_APPROVERS

Details

Schema: FUSION
Object owner: POI
Object type: VIEW

Columns

Name
APPROVER COMPOSITEINSTANCEID REQUISITION_HEADER_ID DOCUMENT_STATUS

Name

APPROVER

COMPOSITEINSTANCEID

REQUISITION_HEADER_ID

DOCUMENT_STATUS

Query

SQL_Statement
select ppn.display_name approver, '-1' compositeinstanceid, object_id requisition_header_id, 'APPROVED' document_status from po_Action_history pah, PER_PERSON_NAMES_F_V ppn where ppn.person_id(+) = pah.performer_id and object_type_code ='REQ' and action_code = 'APPROVE' and sequence_num in (select max(sequence_num) from po_action_history where object_id = pah.object_id and object_type_Code = 'REQ' and action_code = 'APPROVE')

SQL_Statement

select ppn.display_name approver,

'-1' compositeinstanceid,

object_id requisition_header_id,

'APPROVED' document_status

from po_Action_history pah,

PER_PERSON_NAMES_F_V ppn

where ppn.person_id(+) = pah.performer_id

and object_type_code ='REQ'

and action_code = 'APPROVE'

and sequence_num in (select max(sequence_num) from po_action_history where object_id = pah.object_id and object_type_Code = 'REQ' and action_code = 'APPROVE')