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: PA.PA_INTEGRATION_SETTINGS

Object Details

Object Name:	PA_INTEGRATION_SETTINGS
Object Type:	TABLE
Owner:	PA
FND Design Data:	PA.PA_INTEGRATION_SETTINGS
Subobject Name:
Status:	VALID

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
PROJECT_ID	NUMBER	(15)	Yes	The identifier of the project
ENABLE_INTEGRATION	VARCHAR2	(3)	Yes	The identifier for integration to be enabled
STRUCTURE_TYPE	VARCHAR2	(20)		The identifier for the structure type being integrated
SEND_ACTUAL_COST_TYPE	VARCHAR2	(50)		The identifier actual cost type integration
SEND_TASK	VARCHAR2	(3)		The identifier for integrating task information
SEND_TASK_REF	VARCHAR2	(20)		The identifier for the version of the task structure being integrated
RECEIVE_TASK	VARCHAR2	(3)		The identifier for integrating task information
SEND_BUDGET	VARCHAR2	(3)		The identifier for integrating budget information
SEND_BUDGET_REF	VARCHAR2	(20)		The identifier for integrating budget version information
RECEIVE_BUDGET	VARCHAR2	(3)		The identifier for integrating budget information
FIN_PLAN_TYPE_ID	NUMBER	(10)		The identifier for integrating budget information
FIN_STRUCT_MAX_LEVEL	NUMBER	(5)		The identifier for integrating the decided number of WBS levels
BUDGET_TYPE	VARCHAR2	(30)		The identifier for integrating budget type information
SYNCHRONIZE_MARK	VARCHAR2	(3)		The identifier for quick integration of marked projects
LAST_SYNCHRONIZATION_DATE	DATE			The identifier for last integration date
SYNCHRONIZATION_STAGE	VARCHAR2	(20)		The identifier for the stage of synchronization. To be used with error persistance
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)	Yes	Standard Who Column
CREATE_PLANNING_RESOURCE	VARCHAR2	(3)		The identifier for Planning Resource Creation

Query Text

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


SELECT PROJECT_ID
,      ENABLE_INTEGRATION
,      STRUCTURE_TYPE
,      SEND_ACTUAL_COST_TYPE
,      SEND_TASK
,      SEND_TASK_REF
,      RECEIVE_TASK
,      SEND_BUDGET
,      SEND_BUDGET_REF
,      RECEIVE_BUDGET
,      FIN_PLAN_TYPE_ID
,      FIN_STRUCT_MAX_LEVEL
,      BUDGET_TYPE
,      SYNCHRONIZE_MARK
,      LAST_SYNCHRONIZATION_DATE
,      SYNCHRONIZATION_STAGE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      CREATE_PLANNING_RESOURCE
FROM PA.PA_INTEGRATION_SETTINGS;

Dependencies

[top of page]

PA.PA_INTEGRATION_SETTINGS does not reference any database object

PA.PA_INTEGRATION_SETTINGS is referenced by following:

PA: PA_INTEGRATION_SETTINGS#