Patch not applicable in 11.5.9 version

  Hi All, 

Problem Summary
---------------------------------------------------
Slow performance issue in Create Internal Order Program

Problem Description
---------------------------------------------------
Hi ,

The below query is causing perf issue in Oracle standard program " create internal orders "

UPDATE PO_REQUISITION_HEADERS PRH SET PRH.TRANSFERRED_TO_OE_FLAG='I' 

WHERE NVL(PRH.TRANSFERRED_TO_OE_FLAG, 'N')='N' 

AND PRH.AUTHORIZATION_STATUS='APPROVED' 

AND EXISTS (SELECT /*+ HASH_SJ */ 'At least one inventory sourced line' 

FROM PO_REQUISITION_LINES PRL 

WHERE PRH.REQUISITION_HEADER_ID=PRL.REQUISITION_HEADER_ID 

AND PRL.SOURCE_TYPE_CODE='INVENTORY' 

AND NVL(PRL.CANCEL_FLAG, 'N')='N' 

AND NVL(PRL.CLOSED_CODE, 'OPEN') <> 'FINALLY CLOSED'.