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]

TABLE: AMS.AMS_DELIVERABLES_ALL_B

Object Details

Object Name:	AMS_DELIVERABLES_ALL_B
Object Type:	TABLE
Owner:	AMS
FND Design Data:	AMS.AMS_DELIVERABLES_ALL_B
Subobject Name:
Status:	VALID

AMS_DELIVERABLES_ALL_B stores promotional or marketing collateral produced. A Deliverable is unique by Name, Language and Version. They are instances of material, media and fulfilment items produced as part of an Promotion.
- Materials items include brochures, booklets etc.
- Media items include TV and Radio Commercials, questionaires etc.
- Fulfillment items include cuddly toys, brochures, letters etc. These will be sent to the distribution channels, internal and external for delivery to the customers.
Some examples could be:
Letters
- Personal
- Standard in red colours
Brochures
Calling Cards
Envelopes
Promotional Items
- Key ring
TV Commercials
- "True Voice"
- "Sprint Sense"

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_DELIVERABLES_ALL_B_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	DELIVERABLE_ID
AMS_DELIVERABLES_ALL_B_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	STATUS_CODE
AMS_DELIVERABLES_ALL_B_N10	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	INVENTORY_ITEM_ID
AMS_DELIVERABLES_ALL_B_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ORG_ID
AMS_DELIVERABLES_ALL_B_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	LANGUAGE_CODE
AMS_DELIVERABLES_ALL_B_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CHARGEBACK_AMOUNT_CURR_CODE
AMS_DELIVERABLES_ALL_B_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CATEGORY_SUB_TYPE_ID
AMS_DELIVERABLES_ALL_B_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CATEGORY_TYPE_ID
AMS_DELIVERABLES_ALL_B_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OWNER_USER_ID
AMS_DELIVERABLES_ALL_B_N9	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	USER_STATUS_ID

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.
APPLICATION_ID	NUMBER		Yes	Application identifier
USER_STATUS_ID	NUMBER			User status identifier
STATUS_CODE	VARCHAR2	(30)		Status code
STATUS_DATE	DATE			Date status was set
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
OWNER_USER_ID	NUMBER	(15)	Yes	Deliverable owner identifier
ORG_ID	NUMBER	(32)		Operating Unit Identifier
FUND_SOURCE_ID	NUMBER			Fund source identifier.
FUND_SOURCE_TYPE	VARCHAR2	(30)		Fund source type.
CATEGORY_TYPE_ID	NUMBER			Deliverable category type identifier
CATEGORY_SUB_TYPE_ID	NUMBER			Deliverable sub category type identifier
KIT_FLAG	VARCHAR2	(1)		Flag that indicates if the deliverable is a kit, which contains other deilverable items
INVENTORY_FLAG	VARCHAR2	(1)		Flag that indicates if the deliverable item is stored in inventory.
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
REPLACED_BY_DELIVERABLE_ID	NUMBER			This is a superceded deliverable. Another deliverable has replaced this item.
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.
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
ACTUAL_AVAIL_FROM_DATE	DATE			Actual available date for this deliverable
ACTUAL_AVAIL_TO_DATE	DATE			Actual available end date for this deliverable
CHARGEBACK_AMOUNT	NUMBER	(15)		Charge back amount of this deliverable
CHARGEBACK_UOM	VARCHAR2	(3)		Unit of measure of this chargeback amount
CHARGEBACK_AMOUNT_CURR_CODE	VARCHAR2	(15)		chargeback amount currency code
DELIVERABLE_CODE	VARCHAR2	(100)		For backward compatibility only
DELIVERABLE_PICK_FLAG	VARCHAR2	(1)		Flag that indicates this deliverable is picked by other objects.
CURRENCY_CODE	VARCHAR2	(15)		Currency code
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)		This column is not used.
DEFAULT_APPROVER_ID	NUMBER	(15)		Default approver user identifier for this 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
FORECASTED_COMPLETE_DATE	DATE			Forecasted date for deliverable creation completion.
ACTUAL_COMPLETE_DATE	DATE			Actual date for deliverable creation completion.
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
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
COUNTRY_ID	NUMBER			Denotes the hierarchy id of the country in which the deliverable is created.
CUSTOM_SETUP_ID	NUMBER			Denotes the custom setup used to create the deliverable.
EMAIL_CONTENT_TYPE	VARCHAR2	(30)		Deliverable Content type

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
,      APPLICATION_ID
,      USER_STATUS_ID
,      STATUS_CODE
,      STATUS_DATE
,      ACTIVE_FLAG
,      PRIVATE_FLAG
,      OWNER_USER_ID
,      ORG_ID
,      FUND_SOURCE_ID
,      FUND_SOURCE_TYPE
,      CATEGORY_TYPE_ID
,      CATEGORY_SUB_TYPE_ID
,      KIT_FLAG
,      INVENTORY_FLAG
,      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
,      REPLACED_BY_DELIVERABLE_ID
,      CAN_FULFILL_ELECTRONIC_FLAG
,      CAN_FULFILL_PHYSICAL_FLAG
,      JTF_AMV_ITEM_ID
,      TRANSACTION_CURRENCY_CODE
,      FUNCTIONAL_CURRENCY_CODE
,      BUDGET_AMOUNT_TC
,      BUDGET_AMOUNT_FC
,      ACTUAL_AVAIL_FROM_DATE
,      ACTUAL_AVAIL_TO_DATE
,      CHARGEBACK_AMOUNT
,      CHARGEBACK_UOM
,      CHARGEBACK_AMOUNT_CURR_CODE
,      DELIVERABLE_CODE
,      DELIVERABLE_PICK_FLAG
,      CURRENCY_CODE
,      FORECASTED_COST
,      ACTUAL_COST
,      FORECASTED_RESPONSES
,      ACTUAL_RESPONSES
,      COUNTRY
,      DEFAULT_APPROVER_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      FORECASTED_COMPLETE_DATE
,      ACTUAL_COMPLETE_DATE
,      SECURITY_GROUP_ID
,      DELIVERABLE_CALENDAR
,      START_PERIOD_NAME
,      END_PERIOD_NAME
,      ACCOUNTS_CLOSED_FLAG
,      COUNTRY_ID
,      CUSTOM_SETUP_ID
,      EMAIL_CONTENT_TYPE
FROM AMS.AMS_DELIVERABLES_ALL_B;

Dependencies

[top of page]

AMS.AMS_DELIVERABLES_ALL_B does not reference any database object

AMS.AMS_DELIVERABLES_ALL_B is referenced by following:

APPS: AMS_DELIVERABLES_ALL_B