hi.
I have a very strange problem. I run a query in SQL (see below) and I get no errors, and the expected result. I run the same query in Qlikview script, and I get the error: "interface: ORA-00942: table or view does not exist".
SQL
WITH T_INPECT AS
(SELECT C.LOT_ID,
C.WIP_SEQ_NO,
C.PROCESS_CODE,
C.EQUIPMENT_ID,
SUM(DECODE(C.CLCT_ITEM_CODE, 'Temperature', C.CLCT_ITEM1_VALUE)) AS TEMPERATURE,
C.LAST_TRANSACTION_DATE
FROM TB_SFC_WIP_DATA_CLCT_N C
WHERE C.PROCESS_CODE IN ('E0001')
AND C.CLCT_ITEM_CODE IN ('Temperature')
AND C.LAST_TRANSACTION_DATE >= TRUNC(SYSDATE) - 1
AND EXISTS (SELECT 1
FROM TB_EGN_EQUIP_SPEC_MST E
WHERE E.EQUIPMENT_ID = C.EQUIPMENT_ID
AND E.FACTORY_AREA_ID = 'MXPM-01-006'
AND E.REPRESENTATIVE_FACTORY_CODE = 'PM'
AND E.USE_FLAG = 'Y')
GROUP BY C.LOT_ID,
C.WIP_SEQ_NO,
C.LAST_TRANSACTION_DATE,
C.PROCESS_CODE,
C.EQUIPMENT_ID)
SELECT P.WIP_LINE_CODE PCSGNAME,
FN_GET_NAME_BY_LANGID('en-US', PP.PRODUCTION_PROCESS_DESC) PROCNAME,
H.PRODUCT_SPECIFICATION_ID PRODID,
H.LOT_ID LOTID,
FN_GET_NAME_BY_LANGID('en-US', E.EQUIPMENT_DESC) EQPTNAME,
H.EQUIPMENT_ID EQPTID,
TEMPERATURE,
TO_TIMESTAMP(T.LAST_TRANSACTION_DATE,'YYYY-MM-DD HH24:MI:SS.FF6') AS ACTDTTM2,
TO_CHAR(T.LAST_TRANSACTION_DATE, 'YYYYMMDD HH24:MI:SS') AS ACTDTTM,
PP.PROCESS_CODE PROCID
FROM T_INPECT T,
TB_SFC_WIP_H H,
TB_MMD_WIP_LINE_M P,
TB_EGN_PRCS_MST PP,
TB_EGN_EQUIP_SPEC_MST E
WHERE T.LOT_ID = H.LOT_ID
AND T.WIP_SEQ_NO = H.WIP_SEQ_NO
AND H.WIP_LINE_ID = P.WIP_LINE_ID
AND PP.FACILITY_CODE = 'PM_EVZ_FA'
AND PP.PROCESS_CODE = T.PROCESS_CODE
AND E.EQUIPMENT_ID = T.EQUIPMENT_ID
AND E.REPRESENTATIVE_FACTORY_CODE = 'PM';
Does anybody have an idea of the cause?
Thanks in advance.
