Bundles Query:
SELECT A.UPDATE_ID,
A.DESCR,
A.DTTM_IMPORTED,
A.FIXOPRID,
A.APPLYOPRID,
A.PRODUCT_LINE,
A.RELEASEDTTM,
A.RELEASELABEL,
A.MAINTLOGTYPE,
A.DESCRLONG
FROM PS_MAINTENANCE_LOG A
WHERE upper(A.DESCRLONG) LIKE '%BUNDLE%'
ORDER BY 2 DESC;
Tax Update Query:
SELECT A.UPDATE_ID,
A.DESCR,
A.DTTM_IMPORTED,
A.FIXOPRID,
A.APPLYOPRID,
A.PRODUCT_LINE,
A.RELEASEDTTM,
A.RELEASELABEL,
A.MAINTLOGTYPE,
A.DESCRLONG
FROM PS_MAINTENANCE_LOG A
WHERE upper(A.DESCRLONG) LIKE '%TAX UPDATE%'
ORDER BY 2 DESC;
SELECT A.UPDATE_ID,
A.DESCR,
A.DTTM_IMPORTED,
A.FIXOPRID,
A.APPLYOPRID,
A.PRODUCT_LINE,
A.RELEASEDTTM,
A.RELEASELABEL,
A.MAINTLOGTYPE,
A.DESCRLONG
FROM PS_MAINTENANCE_LOG A
WHERE upper(A.DESCRLONG) LIKE '%BUNDLE%'
ORDER BY 2 DESC;
Tax Update Query:
SELECT A.UPDATE_ID,
A.DESCR,
A.DTTM_IMPORTED,
A.FIXOPRID,
A.APPLYOPRID,
A.PRODUCT_LINE,
A.RELEASEDTTM,
A.RELEASELABEL,
A.MAINTLOGTYPE,
A.DESCRLONG
FROM PS_MAINTENANCE_LOG A
WHERE upper(A.DESCRLONG) LIKE '%TAX UPDATE%'
ORDER BY 2 DESC;
No comments:
Post a Comment