[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: |
APPS.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 |