VIEW: APPS.ICX_CAT_LATEST_BATCH_JOBS_V

Source

View Text - Preformatted

SELECT lv.meaning AS job_status_display, lv.lookup_code AS job_status, bj.job_number, bj.ROLE, bj.po_header_id, bj.created_by, DECODE(lv.lookup_code, 'ERROR', 1, 0) as is_error FROM icx_cat_batch_jobs bj, fnd_concurrent_requests cr, fnd_lookup_values_vl lv WHERE bj.job_number = cr.request_id AND lv.lookup_type = 'ICX_CAT_BATCH_JOB_STATUS' AND lv.lookup_code = DECODE(bj.job_status, 'COMPLETED', 'COMPLETED', 'ERROR', 'ERROR', DECODE(cr.status_code, 'E', 'ERROR', 'T', 'ERROR', 'X', 'ERROR', 'D', 'ERROR', bj.job_status)) AND bj.job_type IN ('CATALOG_DATA_TXT_UPLOAD', 'CATALOG_DATA_XML_CHECK', 'CATALOG_DATA_XML_UPLOAD', 'CATALOG_DATA_CXML_CHECK', 'CATALOG_DATA_CXML_UPLOAD', 'CATALOG_DATA_CIF_UPLOAD') AND cr.request_date = (SELECT MAX(cr2.request_date) FROM icx_cat_batch_jobs bj2, fnd_concurrent_requests cr2 WHERE bj2.job_number = cr2.request_id AND bj2.ROLE = bj.ROLE AND bj2.po_header_id = bj.po_header_id)

View Text - HTML Formatted

SELECT LV.MEANING AS JOB_STATUS_DISPLAY
, LV.LOOKUP_CODE AS JOB_STATUS
, BJ.JOB_NUMBER
, BJ.ROLE
, BJ.PO_HEADER_ID
, BJ.CREATED_BY
, DECODE(LV.LOOKUP_CODE
, 'ERROR'
, 1
, 0) AS IS_ERROR
FROM ICX_CAT_BATCH_JOBS BJ
, FND_CONCURRENT_REQUESTS CR
, FND_LOOKUP_VALUES_VL LV
WHERE BJ.JOB_NUMBER = CR.REQUEST_ID
AND LV.LOOKUP_TYPE = 'ICX_CAT_BATCH_JOB_STATUS'
AND LV.LOOKUP_CODE = DECODE(BJ.JOB_STATUS
, 'COMPLETED'
, 'COMPLETED'
, 'ERROR'
, 'ERROR'
, DECODE(CR.STATUS_CODE
, 'E'
, 'ERROR'
, 'T'
, 'ERROR'
, 'X'
, 'ERROR'
, 'D'
, 'ERROR'
, BJ.JOB_STATUS))
AND BJ.JOB_TYPE IN ('CATALOG_DATA_TXT_UPLOAD'
, 'CATALOG_DATA_XML_CHECK'
, 'CATALOG_DATA_XML_UPLOAD'
, 'CATALOG_DATA_CXML_CHECK'
, 'CATALOG_DATA_CXML_UPLOAD'
, 'CATALOG_DATA_CIF_UPLOAD')
AND CR.REQUEST_DATE = (SELECT MAX(CR2.REQUEST_DATE)
FROM ICX_CAT_BATCH_JOBS BJ2
, FND_CONCURRENT_REQUESTS CR2
WHERE BJ2.JOB_NUMBER = CR2.REQUEST_ID
AND BJ2.ROLE = BJ.ROLE
AND BJ2.PO_HEADER_ID = BJ.PO_HEADER_ID)