Product: | QP - Advanced Pricing |
---|---|
Description: | Obsolete |
Implementation/DBA Data: | APPS.QP_ENTITY_PARAMETERS_V |
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)