eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: AMS_P_DELIVERABLES_V

Product:	AMS - Marketing
Description:	This public view returns the marketing deliverable information.
Implementation/DBA Data:	APPS.AMS_P_DELIVERABLES_V

View Text

SELECT B.DELIVERABLE_ID
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_LOGIN
, B.OBJECT_VERSION_NUMBER
, B.LANGUAGE_CODE
, B.VERSION
, B.ACTIVE_FLAG
, B.PRIVATE_FLAG
, B.APPLICATION_ID
, B.USER_STATUS_ID
, ST.NAME USER_STATUS
, B.STATUS_CODE
, B.STATUS_DATE
, B.OWNER_USER_ID
, U.FULL_NAME OWNER
, B.FUND_SOURCE_ID
, B.FUND_SOURCE_TYPE
, B.CATEGORY_TYPE_ID
, C1.CATEGORY_NAME
, B.CATEGORY_SUB_TYPE_ID
, C2.CATEGORY_NAME
, B.KIT_FLAG
, B.CAN_FULFILL_ELECTRONIC_FLAG
, B.CAN_FULFILL_PHYSICAL_FLAG
, B.JTF_AMV_ITEM_ID
, B.INVENTORY_FLAG
, B.ACTUAL_AVAIL_FROM_DATE
, B.ACTUAL_AVAIL_TO_DATE
, B.FORECASTED_COMPLETE_DATE
, B.ACTUAL_COMPLETE_DATE
, B.TRANSACTION_CURRENCY_CODE
, B.FUNCTIONAL_CURRENCY_CODE
, B.BUDGET_AMOUNT_TC
, B.BUDGET_AMOUNT_FC
, B.REPLACED_BY_DELIVERABLE_ID
, B.INVENTORY_ITEM_ID
, B.INVENTORY_ITEM_ORG_ID
, B.PRICELIST_HEADER_ID
, B.PRICELIST_LINE_ID
, B.NON_INV_CTRL_CODE
, B.NON_INV_QUANTITY_ON_HAND
, B.NON_INV_QUANTITY_ON_ORDER
, B.NON_INV_QUANTITY_ON_RESERVE
, B.CHARGEBACK_AMOUNT
, B.CHARGEBACK_AMOUNT_CURR_CODE
, B.DELIVERABLE_CODE
, B.DELIVERABLE_PICK_FLAG
, B.CURRENCY_CODE
, B.FORECASTED_COST
, B.ACTUAL_COST
, B.FORECASTED_RESPONSES
, B.ACTUAL_RESPONSES
, B.COUNTRY
, B.ATTRIBUTE_CATEGORY
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.CHARGEBACK_UOM
, B.DELIVERABLE_CALENDAR
, B.START_PERIOD_NAME
, B.END_PERIOD_NAME
, B.ACCOUNTS_CLOSED_FLAG
, B.DELIVERABLE_NAME
, B.DESCRIPTION
, B.COUNTRY_ID
, B.CUSTOM_SETUP_ID
FROM AMS_DELIVERABLES_VL B
, AMS_CATEGORIES_TL C1
, AMS_CATEGORIES_TL C2
, AMS_USER_STATUSES_VL ST
, AMS_JTF_RS_EMP_V U
WHERE B.CATEGORY_TYPE_ID = C1.CATEGORY_ID
AND C1.LANGUAGE = USERENV('LANG')
AND B.CATEGORY_SUB_TYPE_ID = C2.CATEGORY_ID
AND C2.LANGUAGE = USERENV('LANG')
AND B.USER_STATUS_ID = ST.USER_STATUS_ID
AND B.OWNER_USER_ID = U.RESOURCE_ID

Columns

Name
DELIVERABLE_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
OBJECT_VERSION_NUMBER
LANGUAGE_CODE
VERSION
ACTIVE_FLAG
PRIVATE_FLAG
APPLICATION_ID
USER_STATUS_ID
USER_STATUS
STATUS_CODE
STATUS_DATE
OWNER_USER_ID
OWNER
FUND_SOURCE_ID
FUND_SOURCE_TYPE
CATEGORY_TYPE_ID
DELIVERABLE_CATEGORY
CATEGORY_SUB_TYPE_ID
DELIVERABLE_SUB_CATEGORY
KIT_FLAG
CAN_FULFILL_ELECTRONIC_FLAG
CAN_FULFILL_PHYSICAL_FLAG
JTF_AMV_ITEM_ID
INVENTORY_FLAG
ACTUAL_AVAIL_FROM_DATE
ACTUAL_AVAIL_TO_DATE
FORECASTED_COMPLETE_DATE
ACTUAL_COMPLETE_DATE
TRANSACTION_CURRENCY_CODE
FUNCTIONAL_CURRENCY_CODE
BUDGET_AMOUNT_TC
BUDGET_AMOUNT_FC
REPLACED_BY_DELIVERABLE_ID
INVENTORY_ITEM_ID
INVENTORY_ITEM_ORG_ID
PRICELIST_HEADER_ID
PRICELIST_LINE_ID
NON_INV_CTRL_CODE
NON_INV_QUANTITY_ON_HAND
NON_INV_QUANTITY_ON_ORDER
NON_INV_QUANTITY_ON_RESERVE
CHARGEBACK_AMOUNT
CHARGEBACK_AMOUNT_CURR_CODE
DELIVERABLE_CODE
DELIVERABLE_PICK_FLAG
CURRENCY_CODE
FORECASTED_COST
ACTUAL_COST
FORECASTED_RESPONSES
ACTUAL_RESPONSES
COUNTRY
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CHARGEBACK_UOM
DELIVERABLE_CALENDAR
START_PERIOD_NAME
END_PERIOD_NAME
ACCOUNTS_CLOSED_FLAG
DELIVERABLE_NAME
DESCRIPTION
COUNTRY_ID
CUSTOM_SETUP_ID