[Home] [Help] [Dependency Information]
Object Name: | PA_INTEGRATION_SETTINGS# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROJECT_ID | NUMBER | (15) | Yes | |
ENABLE_INTEGRATION | VARCHAR2 | (3) | Yes | |
STRUCTURE_TYPE | VARCHAR2 | (20) | ||
SEND_ACTUAL_COST_TYPE | VARCHAR2 | (50) | ||
SEND_TASK | VARCHAR2 | (3) | ||
SEND_TASK_REF | VARCHAR2 | (20) | ||
RECEIVE_TASK | VARCHAR2 | (3) | ||
SEND_BUDGET | VARCHAR2 | (3) | ||
SEND_BUDGET_REF | VARCHAR2 | (20) | ||
RECEIVE_BUDGET | VARCHAR2 | (3) | ||
FIN_PLAN_TYPE_ID | NUMBER | (10) | ||
FIN_STRUCT_MAX_LEVEL | NUMBER | (5) | ||
BUDGET_TYPE | VARCHAR2 | (30) | ||
SYNCHRONIZE_MARK | VARCHAR2 | (3) | ||
LAST_SYNCHRONIZATION_DATE | DATE | |||
SYNCHRONIZATION_STAGE | VARCHAR2 | (20) | ||
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 | |
CREATE_PLANNING_RESOURCE | VARCHAR2 | (3) |
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#;
|
|
|