[Home] [Help] [Dependency Information]
Object Name: | AMS_P_DELIVERABLES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_P_DELIVERABLES_V |
Subobject Name: | |
Status: | VALID |
A public view which may be useful for custom reporting or other data
requirements.
This public view returns the marketing deliverable information.
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 |
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;
|
|
|