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 |
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'
, '')