How to find the all cancel PO Requisitions in oracle apps EBS R12
---- All cancel PO Requisitions -----
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
---------------- END -------------
---- All cancel PO Requisitions -----
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
---------------- END -------------
No comments:
Post a Comment