FND Design Data [Home] [Help]

View: JTF_FM_AMV_ITEMS_VL

Product: JTF - CRM Foundation
Description: View referring to the JTF_AMV_ITEMS_VL view
Implementation/DBA Data: ViewAPPS.JTF_FM_AMV_ITEMS_VL
View Text

SELECT ROW_ID
, ITEM_ID
, OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, APPLICATION_ID
, ITEM_TYPE
, CONTENT_TYPE_ID
, EFFECTIVE_START_DATE
, EXPIRATION_DATE
, PUBLICATION_DATE
, PRIORITY
, STATUS_CODE
, OWNER_ID
, DEFAULT_APPROVER_ID
, URL_STRING
, LANGUAGE_CODE
, ITEM_DESTINATION_TYPE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ITEM_NAME
, DESCRIPTION
, TEXT_STRING
, NULL
FROM JTF_AMV_ITEMS_VL

Columns

Name
ROW_ID
ITEM_ID
OBJECT_VERSION_NUMBER
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
APPLICATION_ID
ITEM_TYPE
CONTENT_TYPE_ID
EFFECTIVE_START_DATE
EXPIRATION_DATE
PUBLICATION_DATE
PRIORITY
STATUS_CODE
OWNER_ID
DEFAULT_APPROVER_ID
URL_STRING
LANGUAGE_CODE
ITEM_DESTINATION_TYPE
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
ITEM_NAME
DESCRIPTION
TEXT_STRING
F_DELETEDFLAG