FND Design Data [Home] [Help]

View: QP_ENTITY_PARAMETERS_V

Product: QP - Advanced Pricing
Description: Obsolete
Implementation/DBA Data: ViewAPPS.QP_ENTITY_PARAMETERS_V
View Text

SELECT OAOAE.ROWID
, OAOAE.ATTRIBUTE_ID
, OAOAE.ATTRIBUTE_CODE
, OAOAE.LAST_UPDATE_DATE
, OAOAE.LAST_UPDATED_BY
, OAOAE.LAST_UPDATE_LOGIN
, OAOAE.CREATION_DATE
, OAOAE.CREATED_BY
, AOAT.ATTRIBUTE_LABEL_LONG
, AOA.TABLE_NAME
, AOA.COLUMN_NAME
, OAOAE.COLUMN_TYPE_CODE
, QPL.MEANING
, OAOAE.DISCOUNTS_ENABLED_FLAG
, AOAT.ATTRIBUTE_LABEL_LONG
, OAOAE.CONTEXT
, OAOAE.ATTRIBUTE1
, OAOAE.ATTRIBUTE2
, OAOAE.ATTRIBUTE3
, OAOAE.ATTRIBUTE4
, OAOAE.ATTRIBUTE5
, OAOAE.ATTRIBUTE6
, OAOAE.ATTRIBUTE7
, OAOAE.ATTRIBUTE8
, OAOAE.ATTRIBUTE9
, OAOAE.ATTRIBUTE10
, OAOAE.ATTRIBUTE11
, OAOAE.ATTRIBUTE12
, OAOAE.ATTRIBUTE13
, OAOAE.ATTRIBUTE14
, OAOAE.ATTRIBUTE15
FROM OE_AK_OBJ_ATTR_EXT OAOAE
, AK_OBJECT_ATTRIBUTES_TL AOAT
, AK_OBJECT_ATTRIBUTES AOA
, QP_LOOKUPS QPL
WHERE OAOAE.COLUMN_TYPE_CODE = QPL.LOOKUP_CODE
AND QPL.LOOKUP_TYPE = 'COLUMN_TYPE_CODE'
AND OAOAE.ATTRIBUTE_APPLICATION_ID = 660
AND AOAT.LANGUAGE = USERENV('LANG')
AND AOA.ATTRIBUTE_APPLICATION_ID=AOAT.ATTRIBUTE_APPLICATION_ID
AND AOA.ATTRIBUTE_CODE = AOAT.ATTRIBUTE_CODE
AND AOA.DATABASE_OBJECT_NAME = AOAT.DATABASE_OBJECT_NAME
AND OAOAE.ATTRIBUTE_APPLICATION_ID= AOA.ATTRIBUTE_APPLICATION_ID
AND OAOAE.ATTRIBUTE_CODE=AOA.ATTRIBUTE_CODE
AND OAOAE.DATABASE_OBJECT_NAME = AOA.DATABASE_OBJECT_NAME
AND OAOAE.ATTRIBUTE_ID IN (1325
, 1467
, 1468
, 1053
, 1208
, 1241
, 1239
, 1242
, 1243
, 1244
, 1245
, 1246
, 1247
, 1249)

Columns

Name
ROW_ID
ENTITY_ID
ENTITY_CODE
LAST_UPDATE_DATE
LAST_UPDATED_BY
LAST_UPDATE_LOGIN
CREATION_DATE
CREATED_BY
NAME
TABLE_NAME
COLUMN_NAME
COLUMN_TYPE_CODE
COLUMN_TYPE_MEANING
ENABLED_FLAG
DESCRIPTION
CONTEXT
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15