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_ACT_BUDGETS

Object Details

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

AMS_ACT_BUDGETS stores information about Budget sources & contributions associated with any marketing activity like a Campaign or an Event.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
AMS_ACT_BUDGETS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	ACTIVITY_BUDGET_ID
AMS_ACT_BUDGETS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACT_BUDGET_USED_BY_ID ARC_ACT_BUDGET_USED_BY
AMS_ACT_BUDGETS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	BUDGET_SOURCE_TYPE BUDGET_SOURCE_ID
AMS_ACT_BUDGETS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	CREATION_DATE
AMS_ACT_BUDGETS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ACTIVITY_BUDGET_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.
ACT_BUDGET_USED_BY_ID	NUMBER		Yes	Unique identifier for the marketing activity e.g. CAMPAIGN_ID
ARC_ACT_BUDGET_USED_BY	VARCHAR2	(30)	Yes	Arc qualifier for the marketing activity type e.g. CAMP for Campaigns.
BUDGET_SOURCE_TYPE	VARCHAR2	(30)	Yes	Arc qualifier for the budget type e.g. FUND for Funds..
BUDGET_SOURCE_ID	NUMBER		Yes	Unique identifier for the budget source.
CONTRIBUTION_AMOUNT	NUMBER	(15)
CONTRIBUTION_CURRENCY	VARCHAR2	(15)
CONTRIBUTION_UOM	VARCHAR2	(3)
STATUS_CODE	VARCHAR2	(30)		Recorded status for the budget contribution e.g. APPROVED.
PARTNER_PO_NUMBER	VARCHAR2	(50)		If the budget source is a Partner, this column records the reference information for Partner contribution.
PARTNER_PO_DATE	DATE			If the budget source is a Partner, this column records the reference information for Partner contribution.
PARTNER_PO_APPROVER	VARCHAR2	(120)		If the budget source is a Partner, this column records the reference information for Partner contribution.
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
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
TRANSACTION_TYPE	VARCHAR2	(30)		Records the flow of budget fund e.g. Incoming/Outgoing.
REQUEST_AMOUNT	NUMBER			Budget amount requested from the source.
REQUEST_CURRENCY	VARCHAR2	(15)		Currency for budget request.
REQUEST_DATE	DATE			Date the budget source line was requested for approval.
USER_STATUS_ID	NUMBER		Yes	The internal ID of the status of the budget source.
APPROVED_AMOUNT	NUMBER			Budget amount approved by the source.
APPROVED_ORIGINAL_AMOUNT	NUMBER			Amount approved in the native currency of the budget source.
APPROVED_IN_CURRENCY	VARCHAR2	(15)		Native currency of the budget source.
APPROVAL_DATE	DATE			Date the budget source was appoved by the fund owner.
APPROVER_ID	NUMBER			Resource id for the budget source approver
SPENT_AMOUNT	NUMBER			Amount spent from the approved budget line.
RECAL_FLAG	VARCHAR2	(1)		Flag To indicate Recalculated Committed or not
DATE_REQUIRED_BY	DATE			Required By Date
REQUESTER_ID	NUMBER			Requester Identifier
APPROVED_AMOUNT_FC	NUMBER			Approved Budget Amount in functional currency.
POSTED_FLAG	VARCHAR2	(1)		Flag indicating wether lumsum Offers are posted to the budget or not.
ADJUSTED_FLAG	VARCHAR2	(1)		Flag indicating wether the spent amount has been adjusted to the budget or not.
CONTACT_ID	NUMBER			Partner Contact Indentifier
PARENT_ACT_BUDGET_ID	NUMBER			Parent Activity Budget Identifier.
PARENT_SOURCE_ID	NUMBER			Fund Source of this budget line id .
PARENT_SRC_CURR	VARCHAR2	(30)		Parent Source Apprvd Amount Curr
PARENT_SRC_APPRVD_AMT	NUMBER			Parent Source Approved Amount in parent_src_curr.
REASON_CODE	VARCHAR2	(30)		Transfer Reason Lookup Code .
TRANSFER_TYPE	VARCHAR2	(30)		Transfer Type Identifier for eg. 'REQUEST' , 'TRANSFER'
VENDOR_ID	NUMBER			This is populated for when budget_source_is 'VENDOR'
PARTNER_HOLDING_TYPE	VARCHAR2	(30)		Partner Budget Holding Type . Could be Primary Partner or other Partners.
PARTNER_ADDRESS_ID	NUMBER			Address Id of the Partner or Vendor.
OWNER_ID	NUMBER			Person Idendtifier when budget request is made to a person.
SRC_CURR_REQUEST_AMT	NUMBER			Request Amount in Budget Source Currency

Query Text

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


SELECT ACTIVITY_BUDGET_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_VERSION_NUMBER
,      ACT_BUDGET_USED_BY_ID
,      ARC_ACT_BUDGET_USED_BY
,      BUDGET_SOURCE_TYPE
,      BUDGET_SOURCE_ID
,      CONTRIBUTION_AMOUNT
,      CONTRIBUTION_CURRENCY
,      CONTRIBUTION_UOM
,      STATUS_CODE
,      PARTNER_PO_NUMBER
,      PARTNER_PO_DATE
,      PARTNER_PO_APPROVER
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SECURITY_GROUP_ID
,      TRANSACTION_TYPE
,      REQUEST_AMOUNT
,      REQUEST_CURRENCY
,      REQUEST_DATE
,      USER_STATUS_ID
,      APPROVED_AMOUNT
,      APPROVED_ORIGINAL_AMOUNT
,      APPROVED_IN_CURRENCY
,      APPROVAL_DATE
,      APPROVER_ID
,      SPENT_AMOUNT
,      RECAL_FLAG
,      DATE_REQUIRED_BY
,      REQUESTER_ID
,      APPROVED_AMOUNT_FC
,      POSTED_FLAG
,      ADJUSTED_FLAG
,      CONTACT_ID
,      PARENT_ACT_BUDGET_ID
,      PARENT_SOURCE_ID
,      PARENT_SRC_CURR
,      PARENT_SRC_APPRVD_AMT
,      REASON_CODE
,      TRANSFER_TYPE
,      VENDOR_ID
,      PARTNER_HOLDING_TYPE
,      PARTNER_ADDRESS_ID
,      OWNER_ID
,      SRC_CURR_REQUEST_AMT
FROM AMS.AMS_ACT_BUDGETS;

Dependencies

[top of page]

AMS.AMS_ACT_BUDGETS does not reference any database object

AMS.AMS_ACT_BUDGETS is referenced by following:

APPS: AMS_ACT_BUDGETS