UNPROCESSED & PENDING RECORDS VIEW QUERY FROM BACKEND

Hi All,

From this Query you can view following Records:

UNPROCESSED MATERIAL

UNCOSTED MATERIAL

PENDING WIP COSTING

UNCOSTED WSM

PENDING WSM INTERFACE

PENDING RECEIVING

PENDING MATERIAL

PENDING SHOP FLOOR MOVE

UNPROCESSED SHIPPING TRANSACTIONS

Query : Just change Org ID and Name

SELECT 'UNPROCESSED MATERIAL' TYPE, sysdate Run_time,  ------  163--164 is Org Code and UKD--UKD is Org name-----------

COUNT(DECODE(ORGANIZATION_ID,163,1,NULL)) UKS,

COUNT(DECODE(ORGANIZATION_ID,161,1,NULL)) UKD,

COUNT(DECODE(ORGANIZATION_ID,138,1,NULL)) US1,

COUNT(DECODE(ORGANIZATION_ID,114,1,NULL)) G6,

COUNT(DECODE(ORGANIZATION_ID,112,1,NULL)) C33

FROM MTL_MATERIAL_TRANSACTIONS_TEMP

WHERE NVL(TRANSACTION_STATUS,0) <> 2

UNION ALL

SELECT '