VIEW: APPS.OKX_SYSTEMS_V

Source

View Text - Preformatted

SELECT B.SYSTEM_ID ID1, '#' ID2, B.CUSTOMER_ID CUSTOMER_ID, T.NAME NAME, T.DESCRIPTION DESCRIPTION, B.SERIAL_NUMBER SERIAL_NUMBER, B.COTERMINATE_DAY_MONTH COTERMINATE_DAY_MONTH, B.INSTALL_SITE_USE_ID INSTALL_SITE_USE_ID, B.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID, B.START_DATE_ACTIVE START_DATE_ACTIVE, B.END_DATE_ACTIVE END_DATE_ACTIVE, B.ORG_ID ORG_ID, B.SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID, B.SYSTEM_TYPE_CODE SYSTEM_TYPE_CODE, B.PARENT_SYSTEM_ID PARENT_SYSTEM_ID, B.CONFIG_SYSTEM_TYPE CONFIG_SYSTEM_TYPE, DECODE(SIGN(trunc(sysdate)-NVL(b.start_date_active,trunc(sysdate))),-1,'I', DECODE(SIGN(trunc(sysdate) - NVL(b.end_date_active,trunc(sysdate))), 1,'I','A')) STATUS, NULL INVENTORY_ITEM_ID, NULL ORGANIZATION_ID, NULL PRIMARY_UOM_CODE FROM CS_SYSTEMS_ALL_B B,CS_SYSTEMS_ALL_TL T WHERE B.SYSTEM_ID = T.SYSTEM_ID and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.SYSTEM_ID ID1
, '#' ID2
, B.CUSTOMER_ID CUSTOMER_ID
, T.NAME NAME
, T.DESCRIPTION DESCRIPTION
, B.SERIAL_NUMBER SERIAL_NUMBER
, B.COTERMINATE_DAY_MONTH COTERMINATE_DAY_MONTH
, B.INSTALL_SITE_USE_ID INSTALL_SITE_USE_ID
, B.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, B.START_DATE_ACTIVE START_DATE_ACTIVE
, B.END_DATE_ACTIVE END_DATE_ACTIVE
, B.ORG_ID ORG_ID
, B.SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, B.SYSTEM_TYPE_CODE SYSTEM_TYPE_CODE
, B.PARENT_SYSTEM_ID PARENT_SYSTEM_ID
, B.CONFIG_SYSTEM_TYPE CONFIG_SYSTEM_TYPE
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(B.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE) - NVL(B.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, NULL INVENTORY_ITEM_ID
, NULL ORGANIZATION_ID
, NULL PRIMARY_UOM_CODE
FROM CS_SYSTEMS_ALL_B B
, CS_SYSTEMS_ALL_TL T
WHERE B.SYSTEM_ID = T.SYSTEM_ID
AND T.LANGUAGE = USERENV('LANG')