PO Report Quries
1.CANCELLED PO ’S SELECT PHA . SEGMENT1 , PHA . CREATION_DATE , PLA . CANCEL_DATE , PLA . CANCEL_REASON , PLA . ITEM_DESCRIPTION , HRL . LOCATION_CODE , FU . USER_NAME , DECODE ( PHA . CANCEL_FLAG , 'Y' , ’CANCELLED’) STATUS FROM PO_HEADERS_ALL PHA , PO_LINES_ALL PLA , HR_LOCATIONS HRL , FND_USER FU WHERE PHA . PO_HEADER_ID = PLA . PO_HEADER_ID AND HRL . LOCATION_ID = PHA . SHIP_TO_LOCATION_ID AND PHA . CREATED_BY = FU . USER_ID AND PHA . CANCEL_FLAG = 'Y' 2.PENDING PO ’S SELECT PHA...