Wednesday, June 22, 2011

Canceled Requisitions Query

SELECT prh.requisition_header_id
,prh.preparer_id
,prh.segment1 "REQ NUM"
,TRUNC (prh.creation_date)
,prh.description
,prh.note_to_authorizer
FROM apps.po_requisition_headers_all prh, apps.po_action_history pah
WHERE action_code = 'CANCEL'
AND pah.object_type_code = 'REQUISITION'
AND pah.object_id = prh.requisition_header_id

No comments:

Post a Comment

Best Blogger TipsGet Flower Effect