[Home] [Help] [Dependency Information]
Object Name: | AMS_PROGRAM_COMPONENTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | AMS.AMS_PROGRAM_COMPONENTS_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | 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. |
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;
APPS.AMS_PROGRAM_COMPONENTS_V is not referenced by any database object
|
|
|