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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.AMS_P_DELIVERABLES_V

Object Details

Object Name:	AMS_P_DELIVERABLES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AMS.AMS_P_DELIVERABLES_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

This public view returns the marketing deliverable information.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DELIVERABLE_ID	NUMBER		Yes	Unique identifier
LAST_UPDATE_DATE	DATE		Yes	Standard WHO Column
LAST_UPDATED_BY	NUMBER	(15)	Yes	Standard WHO Column
CREATION_DATE	DATE		Yes	Standard WHO Column
CREATED_BY	NUMBER	(15)	Yes	Standard WHO Column
LAST_UPDATE_LOGIN	NUMBER	(15)		Standard WHO Column
OBJECT_VERSION_NUMBER	NUMBER	(9)		This column is used for locking purposes
LANGUAGE_CODE	VARCHAR2	(4)	Yes	The language code of the language which the translatable fields are translated to
VERSION	VARCHAR2	(10)		Version of this deliverable item.
ACTIVE_FLAG	VARCHAR2	(1)	Yes	Flag that indicates if the deliverable is active
PRIVATE_FLAG	VARCHAR2	(1)	Yes	Flag that indicates if the deliverable is private
APPLICATION_ID	NUMBER		Yes	Application identifier
USER_STATUS_ID	NUMBER			User status identifier
USER_STATUS	VARCHAR2	(120)		User status name
STATUS_CODE	VARCHAR2	(30)		Status code for the deliverable.
STATUS_DATE	DATE			Date status was set
OWNER_USER_ID	NUMBER	(15)	Yes	Deliverable owner identifier
OWNER	VARCHAR2	(360)		Deliverable owner name.
FUND_SOURCE_ID	NUMBER			Fund source identifier. It might be campaign or event identifier.
FUND_SOURCE_TYPE	VARCHAR2	(30)		Fund source type. It might be campaign or event.
CATEGORY_TYPE_ID	NUMBER			Deliverable category type identifier
DELIVERABLE_CATEGORY	VARCHAR2	(120)	Yes	Deliverable category type name.
CATEGORY_SUB_TYPE_ID	NUMBER			Deliverable category sub-type identifier
DELIVERABLE_SUB_CATEGORY	VARCHAR2	(120)	Yes	Deliverable category sub-type name.
KIT_FLAG	VARCHAR2	(1)		Flag that indicates if the deliverable is a kit, which contains other deilverable items
CAN_FULFILL_ELECTRONIC_FLAG	VARCHAR2	(1)		Flag that indicates this deliverable can be fulfilled in electronic format.
CAN_FULFILL_PHYSICAL_FLAG	VARCHAR2	(1)		Flag that indicates this deliverable can be fulfilled physically.
JTF_AMV_ITEM_ID	NUMBER			Item identifier in jtf_amv_item. This deliverable is stored in electronic format and is associated with jtf_amv_item.
INVENTORY_FLAG	VARCHAR2	(1)		Flag that indicates if the deliverable item is stored in inventory.
ACTUAL_AVAIL_FROM_DATE	DATE			Actual available date for this deliverable
ACTUAL_AVAIL_TO_DATE	DATE			Actual available end date for this deliverable
FORECASTED_COMPLETE_DATE	DATE			Actual Complete date.
ACTUAL_COMPLETE_DATE	DATE			Actual Complete date.
TRANSACTION_CURRENCY_CODE	VARCHAR2	(15)		Transactional currency code
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)		Functional currency code
BUDGET_AMOUNT_TC	NUMBER			Budget amount in the transactional currency
BUDGET_AMOUNT_FC	NUMBER			Budget amount in the functional currency
REPLACED_BY_DELIVERABLE_ID	NUMBER			This is a superceded deliverable. Another deliverable has replaced this item.
INVENTORY_ITEM_ID	NUMBER	(38)		Item Identifier in Inventory.
INVENTORY_ITEM_ORG_ID	NUMBER	(32)		Operating Unit Identifier of an Inventory item in inventory.
PRICELIST_HEADER_ID	NUMBER			Pricelist Header ID of the Base Pricelist generated for this Event Offering.
PRICELIST_LINE_ID	NUMBER			Ties in with the Pricelist Header ID.
NON_INV_CTRL_CODE	VARCHAR2	(30)		Number of inventory control code
NON_INV_QUANTITY_ON_HAND	NUMBER	(15)		Quantity on hand of this deliverable
NON_INV_QUANTITY_ON_ORDER	NUMBER	(15)		Quantity on order of this deliverable
NON_INV_QUANTITY_ON_RESERVE	NUMBER	(15)		Quantity on reserve of this deliverable
CHARGEBACK_AMOUNT	NUMBER	(15)		Charge back amount of this deliverable
CHARGEBACK_AMOUNT_CURR_CODE	VARCHAR2	(15)		Chargeback amount currency code
DELIVERABLE_CODE	VARCHAR2	(100)		For backward compatibility only
DELIVERABLE_PICK_FLAG	VARCHAR2	(1)		For backward compatibility. Flag that indicates this deliverable is picked by other objects.
CURRENCY_CODE	VARCHAR2	(15)		For backward compatibility only
FORECASTED_COST	NUMBER	(15)		Forecasted cost of this deliverable
ACTUAL_COST	NUMBER	(15)		Actual cost of this deliverable
FORECASTED_RESPONSES	NUMBER	(15)		Forecasted response number
ACTUAL_RESPONSES	NUMBER	(15)		Actual response number
COUNTRY	VARCHAR2	(240)		Country code for the deliverable.
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfiled structure defining column
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
CHARGEBACK_UOM	VARCHAR2	(3)		Unit of measure of this chargeback amount
DELIVERABLE_CALENDAR	VARCHAR2	(15)		Calendar used for deliverable planning. Refers to the General Ledger calendar.
START_PERIOD_NAME	VARCHAR2	(15)		Starting period name within the deliverable calendar
END_PERIOD_NAME	VARCHAR2	(15)		End period name within the deliverable calendar
ACCOUNTS_CLOSED_FLAG	VARCHAR2	(1)		Flag to indicate closing of Accounts
DELIVERABLE_NAME	VARCHAR2	(240)	Yes	Name of this delvierable
DESCRIPTION	VARCHAR2	(4000)		Description of this delvierable.
COUNTRY_ID	NUMBER			Country identifier
CUSTOM_SETUP_ID	NUMBER			Custom setup for deliverable

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.AMS_P_DELIVERABLES_V;

Dependencies

[top of page]

APPS.AMS_P_DELIVERABLES_V references the following:

APPS: AMS_CATEGORIES_TL; AMS_DELIVERABLES_VL; AMS_JTF_RS_EMP_V; AMS_USER_STATUSES_VL

APPS.AMS_P_DELIVERABLES_V is referenced by following:

APPS: AMS_ACT_DELIVERABLES_V; AMS_P_EVENT_DELIVERABLES_V