Protected by Copyscape Web Copyright Protection Software

Search This Blog

Wednesday, May 29, 2013

How to get the Cancelled Requisitions?

You can get all the Canceled Requisitions in the PO Module using the following Query.

SELECT
prha.requisition_header_id "requisition_header_id"
,prha.segment1 "Requisition Number"
,prha.preparer_id "preparer_id"
,TRUNC(prha.creation_date) "creation_date"
,prha.description "description"
,prha.note_to_authorizer "note_to_authorizer"
FROM
po_requisition_headers_all prha
,po_action_history pah
WHERE action_code='CANCEL'
AND pah.object_type_code='
REQUISITION'
AND pah.object_id=prha.requisition_header_id