VIEW: APPS.QP_ENTITY_PARAMETERS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)