eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: XNC_ITEM_ACTION_PARS_VL

Product:	XNC - Sales for Communications (Obsolete)
Description:	This view is the join of the base table and translation table with all the columns from both table.
Implementation/DBA Data:	Not implemented in this database

View Text

SELECT B.ROWID ROW_ID
, B.ITEM_ACTION_PARAM_ID
, B.ITEM_ACTION_ID
, B.PARAMETER_NAME
, D.MEANING PARAMETER_MEANING
, B.MANDATORY_FLAG
, B.DEFAULT_VALUE
, B.DISPLAY_FLAG
, B.SEQUENCE
, B.SYSTEM_DEFINED_FLAG
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.CONTEXT
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, D.DESCRIPTION PARAMETER_DESCRIPTION
, G.MEANING DISPLAY_MEANING
, B.SOURCE_TYPE_CODE
, E.MEANING SOURCE_TYPE_MEANING
, B.SOURCE_NAME
, DECODE(F.MEANING
, NULL
, ''
, F.MEANING) SOURCE_MEANING
, B.INSTALL_BASE_FLAG
, B.SUBSCRIPTION_FLAG
, B.USER_INSTRUCTION
, B.PARAMETER_SYNCHRONOUS_FLAG
FROM XNC_ITEM_ACTION_PARS_TL T
, XNC_ITEM_ACTION_PARS_B B
, FND_LOOKUP_VALUES_VL D
, FND_LOOKUP_VALUES_VL G
, FND_LOOKUP_VALUES_VL E
, FND_LOOKUP_VALUES_VL F
WHERE B.ITEM_ACTION_PARAM_ID = T.ITEM_ACTION_PARAM_ID
AND T.LANGUAGE = USERENV('LANG')
AND D.LOOKUP_TYPE = 'CSI_EXTEND_ATTRIB_POOL'
AND D.LOOKUP_CODE = B.PARAMETER_NAME
AND G.LOOKUP_TYPE = 'XNC_IA_PARS_DISPLAY'
AND G.LOOKUP_CODE = B.DISPLAY_FLAG
AND E.LOOKUP_TYPE = 'XNC_IA_PARS_SOURCE_TYPE'
AND E.LOOKUP_CODE = F.LOOKUP_TYPE(+)
AND E.LOOKUP_CODE = B.SOURCE_TYPE_CODE
AND F.LOOKUP_CODE = B.SOURCE_NAME UNION SELECT B.ROWID ROW_ID
, B.ITEM_ACTION_PARAM_ID
, B.ITEM_ACTION_ID
, B.PARAMETER_NAME
, D.MEANING PARAMETER_MEANING
, B.MANDATORY_FLAG
, B.DEFAULT_VALUE
, B.DISPLAY_FLAG
, B.SEQUENCE
, B.SYSTEM_DEFINED_FLAG
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.CONTEXT
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, D.DESCRIPTION PARAMETER_DESCRIPTION
, G.MEANING DISPLAY_MEANING
, B.SOURCE_TYPE_CODE
, E.MEANING SOURCE_TYPE_MEANING
, B.SOURCE_NAME
, DECODE(F.MEANING
, NULL
, ''
, F.MEANING) SOURCE_MEANING
, B.INSTALL_BASE_FLAG
, B.SUBSCRIPTION_FLAG
, B.USER_INSTRUCTION
, B.PARAMETER_SYNCHRONOUS_FLAG
FROM XNC_ITEM_ACTION_PARS_TL T
, XNC_ITEM_ACTION_PARS_B B
, FND_LOOKUP_VALUES_VL D
, FND_LOOKUP_VALUES_VL G
, FND_LOOKUP_VALUES_VL E
, FND_LOOKUP_VALUES_VL F
WHERE B.ITEM_ACTION_PARAM_ID = T.ITEM_ACTION_PARAM_ID
AND T.LANGUAGE = USERENV('LANG')
AND D.LOOKUP_TYPE = 'CSI_EXTEND_ATTRIB_POOL'
AND D.LOOKUP_CODE = B.PARAMETER_NAME
AND G.LOOKUP_TYPE = 'XNC_IA_PARS_DISPLAY'
AND G.LOOKUP_CODE = B.DISPLAY_FLAG
AND E.LOOKUP_TYPE = 'XNC_IA_PARS_SOURCE_TYPE'
AND E.LOOKUP_CODE = F.LOOKUP_TYPE(+)
AND E.LOOKUP_CODE = DECODE(B.SOURCE_TYPE_CODE
, 'XNC_PARS_SRC_CUSTOMER'
, 'XNC_PARS_SRC_CUSTOMER'
, '') UNION SELECT B.ROWID ROW_ID
, B.ITEM_ACTION_PARAM_ID
, B.ITEM_ACTION_ID
, B.PARAMETER_NAME
, D.MEANING PARAMETER_MEANING
, B.MANDATORY_FLAG
, B.DEFAULT_VALUE
, B.DISPLAY_FLAG
, B.SEQUENCE
, B.SYSTEM_DEFINED_FLAG
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.CONTEXT
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, D.DESCRIPTION PARAMETER_DESCRIPTION
, G.MEANING DISPLAY_MEANING
, B.SOURCE_TYPE_CODE
, E.MEANING SOURCE_TYPE_MEANING
, B.SOURCE_NAME
, DECODE(F.MEANING
, NULL
, ''
, F.MEANING) SOURCE_MEANING
, B.INSTALL_BASE_FLAG
, B.SUBSCRIPTION_FLAG
, B.USER_INSTRUCTION
, B.PARAMETER_SYNCHRONOUS_FLAG
FROM XNC_ITEM_ACTION_PARS_TL T
, XNC_ITEM_ACTION_PARS_B B
, FND_LOOKUP_VALUES_VL D
, FND_LOOKUP_VALUES_VL G
, FND_LOOKUP_VALUES_VL E
, FND_LOOKUP_VALUES_VL F
WHERE B.ITEM_ACTION_PARAM_ID = T.ITEM_ACTION_PARAM_ID
AND T.LANGUAGE = USERENV('LANG')
AND D.LOOKUP_TYPE = 'CSI_EXTEND_ATTRIB_POOL'
AND D.LOOKUP_CODE = B.PARAMETER_NAME
AND G.LOOKUP_TYPE = 'XNC_IA_PARS_DISPLAY'
AND G.LOOKUP_CODE = B.DISPLAY_FLAG
AND E.LOOKUP_TYPE = 'XNC_IA_PARS_SOURCE_TYPE'
AND E.LOOKUP_CODE = F.LOOKUP_TYPE(+)
AND E.LOOKUP_CODE = DECODE(B.SOURCE_TYPE_CODE
, 'XNC_PARS_SRC_EXTERNAL'
, 'XNC_PARS_SRC_EXTERNAL'
, '')

Columns

Name
ROW_ID
ITEM_ACTION_PARAM_ID
ITEM_ACTION_ID
PARAMETER_NAME
PARAMETER_MEANING
MANDATORY_FLAG
DEFAULT_VALUE
DISPLAY_FLAG
SEQUENCE
SYSTEM_DEFINED_FLAG
START_DATE_ACTIVE
END_DATE_ACTIVE
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
CONTEXT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
PARAMETER_DESCRIPTION
DISPLAY_MEANING
SOURCE_TYPE_CODE
SOURCE_TYPE_MEANING
SOURCE_NAME
SOURCE_MEANING
INSTALL_BASE_FLAG
SUBSCRIPTION_FLAG
USER_INSTRUCTION
PARAMETER_SYNCHRONOUS_FLAG