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_OPTIONS

Object Details

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

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Mandatory	Comments
INTEGRATION_OPTION_NAME	VARCHAR2	(100)	Yes	Primary Key Column
DESCRIPTION	VARCHAR2	(2000)
ENABLED_FLAG	VARCHAR2	(1)
CURRENCY_CODE	VARCHAR2	(15)
RATE_TYPE_CODE	VARCHAR2	(20)
RATE_DATE_TYPE	VARCHAR2	(20)
RATE_DATE	DATE
PLANNING_RESOURCE_LIST_ID	NUMBER	(15)
EMP_BILL_RATE_SCH_ID	NUMBER
JOB_BILL_RATE_SCH_ID	NUMBER
NON_LABOR_BILL_RATE_SCH_ID	NUMBER
RES_CLASS_BILL_RATE_SCH_ID	NUMBER
INTEGRATION_BATCH_SIZE	NUMBER	(10)
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
LAST_INTEGRATION_DATE	DATE
RESOURCE_SYNCED	VARCHAR2	(1)
INTEGRATION_PROCESS_STATUS	VARCHAR2	(20)

Query Text

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


SELECT INTEGRATION_OPTION_NAME
,      DESCRIPTION
,      ENABLED_FLAG
,      CURRENCY_CODE
,      RATE_TYPE_CODE
,      RATE_DATE_TYPE
,      RATE_DATE
,      PLANNING_RESOURCE_LIST_ID
,      EMP_BILL_RATE_SCH_ID
,      JOB_BILL_RATE_SCH_ID
,      NON_LABOR_BILL_RATE_SCH_ID
,      RES_CLASS_BILL_RATE_SCH_ID
,      INTEGRATION_BATCH_SIZE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_INTEGRATION_DATE
,      RESOURCE_SYNCED
,      INTEGRATION_PROCESS_STATUS
FROM PA.PA_INTEGRATION_OPTIONS;

Dependencies

[top of page]

PA.PA_INTEGRATION_OPTIONS does not reference any database object

PA.PA_INTEGRATION_OPTIONS is referenced by following:

PA: PA_INTEGRATION_OPTIONS#