Product: | INV - Inventory |
---|---|
Description: | 10SC ONLY |
Implementation/DBA Data: | APPS.MTL_INTERFACE_PROC_CONTROLS_V |
SELECT MIPC.ROWID ROW_ID
, MIPC.PROCESS_CODE
, MIPC.LAST_UPDATE_DATE
, MIPC.LAST_UPDATED_BY
, MIPC.CREATION_DATE
, MIPC.CREATED_BY
, MIPC.LAST_UPDATE_LOGIN
, MIPC.REQUEST_ID
, MIPC.PROGRAM_APPLICATION_ID
, MIPC.PROGRAM_ID
, MIPC.PROGRAM_UPDATE_DATE
, MIPC.PROCESS_STATUS
, MIPC.PROCESS_INTERVAL
, MIPC.MANAGER_PRIORITY
, MIPC.WORKER_PRIORITY
, MIPC.WORKER_ROWS
, MIPC.PROCESSING_TIMEOUT
, MIPC.PROCESS_NAME
, MIPC.PROCESS_APP_SHORT_NAME
, A.MEANING PROCESS_TYPE
, FLOOR(MIPC.PROCESS_INTERVAL/3600) PROCESS_HOURS
, FLOOR((MIPC.PROCESS_INTERVAL - (FLOOR(MIPC.PROCESS_INTERVAL/3600) * 3600))/60) PROCESS_MINUTES
, (MIPC.PROCESS_INTERVAL - (FLOOR(MIPC.PROCESS_INTERVAL/3600) * 3600) - (FLOOR((MIPC.PROCESS_INTERVAL - (FLOOR(MIPC.PROCESS_INTERVAL/3600) * 3600))/60) * 60)) PROCESS_SECONDS
, FLOOR(MIPC.PROCESSING_TIMEOUT/3600) TIMEOUT_HOURS
, FLOOR((MIPC.PROCESSING_TIMEOUT - FLOOR(MIPC.PROCESSING_TIMEOUT/3600) * 3600)/60) TIMEOUT_MINUTES
FROM MTL_INTERFACE_PROC_CONTROLS MIPC
, MFG_LOOKUPS A
WHERE A.LOOKUP_TYPE = 'PROCESS_TYPE'
AND A.LOOKUP_CODE = MIPC.PROCESS_CODE