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_PROGRAM_COMPONENTS_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
CAMPAIGN_KEY	VARCHAR2	(70)	Campaign Key of the Program component.
PROGRAM_KEY	VARCHAR2	(70)	Parent Key of the Program component.
CAMPAIGN_ID	NUMBER		Identifier of the Component of the Program.
CAMPAIGN_NAME	VARCHAR2	(240)	Name of the Program component.
PROGRAM_ID	NUMBER		Identifier of the program.
ROLLUP_TYPE	VARCHAR2	(30)	Type of the component.
VERSION_NO	VARCHAR2	(10)	Version no of the component.
SOURCE_CODE	VARCHAR2	(30)	Source code of the component.
STATUS_CODE	VARCHAR2	(30)	Status code of the component.
STATUS_DATE	DATE		Date the status last updated.
USER_STATUS_ID	NUMBER		Identifier of the user status of the component.
USER_STATUS	VARCHAR2	(120)	User Status of the program component.
BUSINESS_UNIT_ID	NUMBER		Business Unit.
PRIORITY	VARCHAR2	(30)	Priority
OBJECT_SUB_TYPE	VARCHAR2	(30)	Subtype of the program component.
START_PERIOD_NAME	VARCHAR2	(15)	Start period name.
START_DATE	DATE		Start Date.
END_PERIOD_NAME	VARCHAR2	(15)	End period name.
END_DATE	DATE		End date.
COUNTRY_ID	NUMBER		Identifier of the country the component created in.
COUNTRY_NAME	VARCHAR2	(240)	Name of the country.
OWNER_ID	NUMBER		Identifier of the owner of the component.
OWNER_NAME	VARCHAR2	(360)	Name of the owner.
OWNER_MAIL_ID	VARCHAR2	(2000)	Owner email address.
DESCRIPTION	VARCHAR2	(4000)	Description.
FUNCTIONAL_CURRENCY_CODE	VARCHAR2	(15)	Functional Currency code.
BUDGET_AMOUNT_FC	NUMBER		Budget amount in functional currency.
TRANSACTION_CURRENCY_CODE	VARCHAR2	(15)	Transaction currency code.
BUDGET_AMOUNT_TC	NUMBER		Budget amount in Transaction currency.
OBJECT_VERSION_NUMBER	NUMBER	(9)	Used for locking purpose.
CUSTOM_SETUP_ID	NUMBER		Identifier of the setup with which program component is created.

Query Text

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


SELECT CAMPAIGN_KEY
,      PROGRAM_KEY
,      CAMPAIGN_ID
,      CAMPAIGN_NAME
,      PROGRAM_ID
,      ROLLUP_TYPE
,      VERSION_NO
,      SOURCE_CODE
,      STATUS_CODE
,      STATUS_DATE
,      USER_STATUS_ID
,      USER_STATUS
,      BUSINESS_UNIT_ID
,      PRIORITY
,      OBJECT_SUB_TYPE
,      START_PERIOD_NAME
,      START_DATE
,      END_PERIOD_NAME
,      END_DATE
,      COUNTRY_ID
,      COUNTRY_NAME
,      OWNER_ID
,      OWNER_NAME
,      OWNER_MAIL_ID
,      DESCRIPTION
,      FUNCTIONAL_CURRENCY_CODE
,      BUDGET_AMOUNT_FC
,      TRANSACTION_CURRENCY_CODE
,      BUDGET_AMOUNT_TC
,      OBJECT_VERSION_NUMBER
,      CUSTOM_SETUP_ID
FROM APPS.AMS_PROGRAM_COMPONENTS_V;

Dependencies

[top of page]

APPS.AMS_PROGRAM_COMPONENTS_V references the following:

APPS: AMS_CAMPAIGNS_ALL_B; AMS_CAMPAIGNS_VL; AMS_EVENT_HEADERS_VL; AMS_EVENT_OFFERS_VL; AMS_USER_STATUSES_TL; JTF_LOC_AREAS_TL; JTF_LOC_HIERARCHIES_B; JTF_RS_RESOURCE_EXTNS_VL

APPS.AMS_PROGRAM_COMPONENTS_V is not referenced by any database object