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
No comments:
Post a Comment