[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_ST_PROJECT_TASKS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.MSC_ST_PROJECT_TASKS
|
| Subobject Name: | |
| Status: | VALID |
The staging table used by the collection program to validate and process data for table MSC_PROJECT_TASKS.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| PROJECT_ID | NUMBER | (15) | Project identifier | |
| TASK_ID | NUMBER | (15) | Task identifier | |
| ORGANIZATION_ID | NUMBER | Organization identifier | ||
| TASK_NUMBER | VARCHAR2 | (25) | Task number | |
| TASK_NAME | VARCHAR2 | (20) | Task name | |
| DESCRIPTION | VARCHAR2 | (250) | Task description | |
| MANAGER | VARCHAR2 | (240) | Manager | |
| START_DATE | DATE | Task start date | ||
| END_DATE | DATE | Task end date | ||
| DELETED_FLAG | NUMBER | Yes/No flag indicates whether corresponding record in ODS will be deleted | ||
| LAST_UPDATE_DATE | DATE | Standard Who column | ||
| LAST_UPDATED_BY | NUMBER | Standard Who column | ||
| CREATION_DATE | DATE | Standard Who column | ||
| CREATED_BY | NUMBER | Standard Who column | ||
| LAST_UPDATE_LOGIN | NUMBER | Standard Who column | ||
| REQUEST_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_APPLICATION_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_ID | NUMBER | Concurrent Who column | ||
| PROGRAM_UPDATE_DATE | DATE | Concurrent Who column | ||
| SR_INSTANCE_ID | NUMBER | Source application instance identifier | ||
| REFRESH_ID | NUMBER | Refresh identifier populated by the collection program | ||
| MANAGER_CONTACT | VARCHAR2 | (100) | Manager Contact | |
| COMPANY_ID | NUMBER | Company identifier | ||
| COMPANY_NAME | VARCHAR2 | (255) | Company name | |
| PROJECT_NUMBER | VARCHAR2 | (25) | Project Name | |
| COSTING_GROUP_ID | NUMBER | Costing Group Id | ||
| COSTING_GROUP_CODE | VARCHAR2 | (10) | Costing group code assigned to this project | |
| SEIBAN_NUMBER_FLAG | NUMBER | (1) | Flag to identify whether project_id identifies a project or seiban | |
| PROJECT_DESCRIPTION | VARCHAR2 | (250) | Project Description | |
| PLANNING_GROUP | VARCHAR2 | (30) | Planning group assigned to this project | |
| WIP_ACCT_CLASS_CODE | VARCHAR2 | (10) | Default wip accounting class assigned to this project | |
| PROJECT_START_DATE | DATE | Project Start Date | ||
| PROJECT_COMPLETION_DATE | DATE | Project Completion Date | ||
| MATERIAL_ACCOUNT | NUMBER | Material account | ||
| ORGANIZATION_CODE | VARCHAR2 | (7) | Organization Code | |
| SR_INSTANCE_CODE | VARCHAR2 | (3) | Source Instance Code | |
| MESSAGE_ID | NUMBER | This is a foreign key reference to ECX_DOCLOGS.INTERNAL_CONTROL_NUMBER for records got via XML | ||
| PROCESS_FLAG | NUMBER | Processing Flag indicating the status of records during pre-processing. 1- New Record, 2- In-Process, 3- Error, 4- Propagated Error, 5- Successfully Processed | ||
| ERROR_TEXT | VARCHAR2 | (2000) | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error | |
| DATA_SOURCE_TYPE | VARCHAR2 | (15) | Source Type indicating the source of the records | |
| ST_TRANSACTION_ID | NUMBER | Transaction ID generated during pre-processing to uniquely identify a record in the staging table | ||
| BATCH_ID | NUMBER | Batch identifier generated during pre-processing | ||
| SOURCE_ORG_ID | NUMBER | This is the Organization ID for the Organization in the legacy(source) system.This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_PROJECT_ID | NUMBER | This is the Project ID for the Project in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_TASK_ID | NUMBER | This is the Task ID for the Task in the legacy (source) system. This is needed to relate the data in planning server to the legacy system and is for reference purpose only. | ||
| SOURCE_COSTING_GROUP_ID | NUMBER | This is the Costing Group ID for the Costing Group in the legacy(source) system.This is needed to relate the data in planning server to the legacy system and is for reference purpose only. |
Cut, paste (and edit) the following text to query this object:
SELECT PROJECT_ID
, TASK_ID
, ORGANIZATION_ID
, TASK_NUMBER
, TASK_NAME
, DESCRIPTION
, MANAGER
, START_DATE
, END_DATE
, DELETED_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, SR_INSTANCE_ID
, REFRESH_ID
, MANAGER_CONTACT
, COMPANY_ID
, COMPANY_NAME
, PROJECT_NUMBER
, COSTING_GROUP_ID
, COSTING_GROUP_CODE
, SEIBAN_NUMBER_FLAG
, PROJECT_DESCRIPTION
, PLANNING_GROUP
, WIP_ACCT_CLASS_CODE
, PROJECT_START_DATE
, PROJECT_COMPLETION_DATE
, MATERIAL_ACCOUNT
, ORGANIZATION_CODE
, SR_INSTANCE_CODE
, MESSAGE_ID
, PROCESS_FLAG
, ERROR_TEXT
, DATA_SOURCE_TYPE
, ST_TRANSACTION_ID
, BATCH_ID
, SOURCE_ORG_ID
, SOURCE_PROJECT_ID
, SOURCE_TASK_ID
, SOURCE_COSTING_GROUP_ID
FROM MSC.MSC_ST_PROJECT_TASKS;
MSC.MSC_ST_PROJECT_TASKS does not reference any database object
MSC.MSC_ST_PROJECT_TASKS is referenced by following:
MSC
MSC_ST_PROJECT_TASKS#
|
|
|
|