DBA Data[Home] [Help] [Dependency Information]

VIEW: PA.PA_INTEGRATION_OPTIONS#

Object Details
Object Name: PA_INTEGRATION_OPTIONS#
Object Type: VIEW
Owner: PA
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
INTEGRATION_OPTION_NAME VARCHAR2 (100) Yes
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
LAST_UPDATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
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# references the following:

SchemaPA
TablePA_INTEGRATION_OPTIONS
PA.PA_INTEGRATION_OPTIONS# is referenced by following:

SchemaAPPS
SynonymPA_INTEGRATION_OPTIONS