document.open();document.writeln('
');document.writeln('
SELECT Z.PART_NO,');document.writeln('       Z.INVENTORY_ITEM_ID ,');document.writeln('       Z.SUBINVENTORY_CODE,');document.writeln('       Z.REVISION,');document.writeln('       Z.TRN_DATE,');document.writeln('       Z.TRN_QTY,');document.writeln('       Z.TRN_NAME,');document.writeln('       Z.TRN_UOM,');document.writeln('       Z.TICKET_NO,');document.writeln('       Z.DEPT_NAME,');document.writeln('       Z.DEPT_CODE,');document.writeln('       Z.APPLICANT,');document.writeln('       Z.VENDOR_CUSTOMER,');document.writeln('       Z.DESCRIPTION ,');document.writeln('       M.DESCRIPTION STKRM_NAME,');document.writeln('       Z.KEEP_LOCATION_TYPE,');document.writeln('       Z.KEEP_LOCATION,');document.writeln('       Z.SOURCE_NO     ,');document.writeln('       Z.REASON_ID');document.writeln('FROM   MTL_SECONDARY_INVENTORIES M,');document.writeln('       (');document.writeln('         SELECT  A.SEGMENT1                         PART_NO,');document.writeln('                 A.DESCRIPTION                      ,');document.writeln('                 B.SUBINVENTORY_CODE                ,');document.writeln('                 B.REVISION                         ,');document.writeln('                 B.TRANSACTION_DATE                 TRN_DATE,');document.writeln('                 B.TRANSACTION_QUANTITY             TRN_QTY,');document.writeln('                 C.LOCATION_CODE                    DEPT_CODE,');document.writeln('                 C.DESCRIPTION                      DEPT_NAME,');document.writeln('                 D.TRANSACTION_TYPE_NAME            TRN_NAME,');document.writeln('                 D.DESCRIPTION                      TRN_NAME_DESC,');document.writeln('                 B.TRANSACTION_UOM                  TRN_UOM,');document.writeln('                 B.ATT1                       TICKET_NO,');document.writeln('                 E.SLIP_NO                          ,');document.writeln('                 B.ORGANIZATION_ID                  ,');document.writeln('                 B.INVENTORY_ITEM_ID                ,');document.writeln('                 B.LOCATOR_ID                       ,');document.writeln('                 B.REASON_ID                        ,');document.writeln('                 B.TRANSACTION_TYPE_ID              ,');document.writeln('                 B.TRANSACTION_ID                   ,');document.writeln('                 B.ATT3                       APPLICANT,');document.writeln('                 B.ATT4                       VENDOR_CUSTOMER,');document.writeln('                 B.ATT7                       SOURCE_NO,');document.writeln('                 E.KEEP_LOCATION_TYPE               ,');document.writeln('                 E.KEEP_LOCATION                    ,');document.writeln('                 SUBSTR(B.TRANSACTION_REFERENCE,1,3) TAIWAN_TRN_TYPE_NAME, ');document.writeln('                 MF.MEANING                          ACTION');document.writeln('           FROM  MTL_SYSTEM_ITEMS          A ,');document.writeln('                 HR_LOCATIONS              C ,');document.writeln('                 MTL_TRANSACTION_TYPES     D ,');document.writeln('                 (');document.writeln('                   SELECT *');document.writeln('                     FROM MTL_MATERIAL_TRANSACTIONS T');document.writeln('                    WHERE T.ORGANIZATION_ID   = 168');document.writeln('                      AND T.TRANSACTION_DATE >= '10-APR-09'');document.writeln('                      AND T.TRANSACTION_DATE  < '11-APR-09'');document.writeln('                 ) B,');document.writeln('                 C_INV_TICKET_HEADERS      E,');document.writeln('                 MFG_LOOKUPS               MF');document.writeln('          WHERE  A.ORGANIZATION_ID        = B.ORGANIZATION_ID');document.writeln('            AND  A.INVENTORY_ITEM_ID      = B.INVENTORY_ITEM_ID');document.writeln('            AND  C.LOCATION_ID(+)         = B.ATT2');document.writeln('            AND  D.TRANSACTION_TYPE_ID    = B.TRANSACTION_TYPE_ID');document.writeln('            AND  E.TRANSACTION_TYPE_ID(+) = B.TRANSACTION_TYPE_ID');document.writeln('            AND  E.TICKET_NO(+)           = SUBSTR(B.ATT1,4,7) ');document.writeln('            AND  E.ORGANIZATION_ID(+)     = B.ORGANIZATION_ID');document.writeln('            AND  MF.LOOKUP_TYPE           = 'MTL_TRANSACTION_ACTION'');document.writeln('            AND  B.TRANSACTION_ACTION_ID  = MF.LOOKUP_CODE');document.writeln('       ) Z ');document.writeln('WHERE Z.ORGANIZATION_ID = 168');document.writeln('  AND Z.SUBINVENTORY_CODE BETWEEN NVL('CAT',Z.SUBINVENTORY_CODE) AND NVL('DOG',Z.SUBINVENTORY_CODE)');document.writeln('  AND Z.PART_NO BETWEEN  NVL('0' ,Z.PART_NO) AND NVL('Z',Z.PART_NO)');document.writeln('  AND ((Z.TRN_NAME BETWEEN  NVL('BOV',Z.TRN_NAME)  AND NVL('BOV',Z.TRN_NAME) )');document.writeln('        OR (Z.TAIWAN_TRN_TYPE_NAME BETWEEN NVL('BOV',Z.TAIWAN_TRN_TYPE_NAME) AND NVL('BOV',Z.TAIWAN_TRN_TYPE_NAME))');document.writeln('      )');document.writeln('  AND M.ORGANIZATION_ID         = Z.ORGANIZATION_ID');document.writeln('  AND M.SECONDARY_INVENTORY_NAME=Z.SUBINVENTORY_CODE');document.writeln('  AND (Z.DEPT_CODE IS NULL OR Z.DEPT_CODE BETWEEN NVL(NULL,Z.DEPT_CODE) AND NVL(NULL,Z.DEPT_CODE) )');document.writeln('  AND ((Z.REASON_ID IS NULL AND NULL IS NULL ) OR ');document.writeln('       (Z.REASON_ID IS NOT NULL AND EXISTS');document.writeln('                    ( SELECT 'X' FROM  MTL_TRANSACTION_REASONS R');document.writeln('                       WHERE  R.REASON_NAME BETWEEN NVL(NULL , R.REASON_NAME)');document.writeln('                         AND NVL(NULL,R.REASON_NAME) AND R.REASON_ID = Z.REASON_ID  ');document.writeln('                    )');document.writeln('       )');document.writeln('      )');document.writeln('ORDER BY TRN_DATE,TRN_NAME,TICKET_NO');document.writeln('
');document.writeln('');document.writeln('');document.writeln('
');document.close();