Open PO script Sample

SELECT
DECODE(PH.ORG_ID,'83','SZ','106','KS','121','DCL','OTHERS') SITES,
PH.SEGMENT1 PO_NUMBER,
PH.AUTHORIZATION_STATUS ,
TO_CHAR(PH.CREATION_DATE,'YYYY-MM-DD') CREATEION_DATE,
PL.LINE_NUM ,
MSIB.SEGMENT1 ITEM_NUMBER,
PL.ITEM_DESCRIPTION ,
PLLA.QUANTITY ,
PLLA.QUANTITY_RECEIVED,
PLLA.QUANTITY_BILLED
FROM
PO_HEADERS_ALL PH ,
PO_LINES_ALL PL ,
MTL_SYSTEM_ITEMS_B MSIB ,
PO_LINE_LOCATIONS_ALL PLLA
WHERE
PH.TYPE_LOOKUP_CODE ='STANDARD'
AND NVL(PH.CLOSED_CODE,'OPEN') ='OPEN'

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

AND PH.PO_HEADER_ID = PL.PO_HEADER_ID

AND NVL(PL.CLOSED_CODE,'OPEN') ='OPEN'
AND NVL(PL.CANCEL_FLAG,'N')='N'
AND MSIB.INVENTORY_ITEM_ID (+)= PL.ITEM_ID
AND MSIB.ORGANIZATION_ID = DECODE(PH.ORG_ID,'83','104','121','122','106','107',-100)

AND PL.PO_LINE_ID = PLLA.PO_LINE_ID
AND PH.PO_HEADER_ID =PLLA.PO_HEADER_ID

AND PLLA.QUANTITY <>PLLA.QUANTITY_RECEIVED

ORDER BY
1,2,5

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16569/viewspace-915215/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16569/viewspace-915215/