[Home] [Help] [Dependency Information]
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"
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
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 |
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 |
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;
AMS.AMS_DELIVERABLES_ALL_B does not reference any database object
AMS.AMS_DELIVERABLES_ALL_B is referenced by following:
|
|
|