Oracle Dev
-
编辑 删除
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 PLLAWHERE PH.TYPE_LOOKUP_CODE ='STANDARD' AND NVL(PH.CLOS
