Skip to content

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: TablePA.PA_INTEGRATION_OPTIONS
Subobject Name:
Status: VALID

Storage Details
Tablespace: TablespaceAPPS_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:

SchemaPA
ViewPA_INTEGRATION_OPTIONS#