VIEW: APPS.OKX_BUS_PROCESSES_V

Source

View Text - Preformatted

SELECT BP.BUSINESS_PROCESS_ID ID1, '#' ID2, BP.NAME NAME, BP.DESCRIPTION DESCRIPTION, DECODE(SIGN(trunc(sysdate)-NVL(bp.start_date_active,trunc(sysdate))),-1,'I', DECODE(SIGN(trunc(sysdate) - NVL(bp.end_date_active,trunc(sysdate))), 1,'I','A')) STATUS, BP.START_DATE_ACTIVE START_DATE_ACTIVE, BP.END_DATE_ACTIVE END_DATE_ACTIVE, NULL INVENTORY_ITEM_ID, NULL ORGANIZATION_ID, NULL PRIMARY_UOM_CODE FROM CS_BUSINESS_PROCESSES BP

View Text - HTML Formatted

SELECT BP.BUSINESS_PROCESS_ID ID1
, '#' ID2
, BP.NAME NAME
, BP.DESCRIPTION DESCRIPTION
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(BP.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(BP.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, BP.START_DATE_ACTIVE START_DATE_ACTIVE
, BP.END_DATE_ACTIVE END_DATE_ACTIVE
, NULL INVENTORY_ITEM_ID
, NULL ORGANIZATION_ID
, NULL PRIMARY_UOM_CODE
FROM CS_BUSINESS_PROCESSES BP