[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | MSC_ST_DESIGNATORS |
|---|---|
| Object Type: | TABLE |
| Owner: | MSC |
| FND Design Data: |  MSC.MSC_ST_DESIGNATORS
|
| Subobject Name: | |
| Status: | VALID |
The staging table used by the collection program to validate and process data for table MSC_DESIGNTORS.
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| DESIGNATOR_ID | NUMBER | Designator identifier | ||
| DESIGNATOR | VARCHAR2 | (10) | Source application schedule name | |
| SR_DESIGNATOR | VARCHAR2 | (10) | Source designator identifier | |
| ORGANIZATION_ID | NUMBER | Organization identifier | ||
| SR_ORGANIZATION_ID | NUMBER | Source organization identifier | ||
| MPS_RELIEF | NUMBER | Flag to indicate whether MPS relief performed against this designator | ||
| INVENTORY_ATP_FLAG | NUMBER | ATP supply flag | ||
| DESCRIPTION | VARCHAR2 | (50) | Description of the this designator | |
| DISABLE_DATE | DATE | Designator disable date | ||
| DEMAND_CLASS | VARCHAR2 | (34) | Demand class code | |
| ORGANIZATION_SELECTION | NUMBER | Single/Multiple organizations | ||
| PRODUCTION | NUMBER | Production flag | ||
| RECOMMENDATION_RELEASE | NUMBER | Planned order release flag | ||
| DESIGNATOR_TYPE | NUMBER | Schedule type | ||
| DELETED_FLAG | NUMBER | Yes/No flag indicating whether the row 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 number populated by the collection program | ||
| CONSUME_FORECAST | NUMBER | Consume forecast flag | ||
| UPDATE_TYPE | NUMBER | Forecast update type code | ||
| FORWARD_UPDATE_TIME_FENCE | NUMBER | Forward consumption days | ||
| BACKWARD_UPDATE_TIME_FENCE | NUMBER | Backward consumption days | ||
| OUTLIER_UPDATE_PERCENTAGE | NUMBER | Forecast outlier update percentage | ||
| FORECAST_SET_ID | VARCHAR2 | (10) | Forecast set identifier | |
| CUSTOMER_ID | NUMBER | Customer identifier | ||
| SHIP_ID | NUMBER | Forecast ship code identifier | ||
| BILL_ID | NUMBER | Forecast billing address identifier | ||
| BUCKET_TYPE | NUMBER | Forecast bucket type - days, weeks or periods | ||
| PROBABILITY | NUMBER | Probability | ||
| FORECAST_SET | VARCHAR2 | (10) | Source Forecast Set | |
| COMPANY_ID | NUMBER | Company identifier | ||
| COMPANY_NAME | VARCHAR2 | (255) | Company name | |
| ORGANIZATION_CODE | VARCHAR2 | (7) | Organization Code | |
| CUSTOMER_NAME | VARCHAR2 | (255) | Customer Name | |
| SHIP_TO_SITE_CODE | VARCHAR2 | (30) | Shipping site code | |
| BILL_TO_SITE_CODE | VARCHAR2 | (30) | Billing site 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 | ||
| DATA_SOURCE_TYPE | VARCHAR2 | (15) | Source type indicating the source of data | |
| ST_TRANSACTION_ID | NUMBER | Transaction ID generated during pre-processing to uniquely identify a record in the staging table | ||
| ERROR_TEXT | VARCHAR2 | (2000) | If PROCESS_FLAG is equal to 3 for a record, then this will describe the reason for the error | |
| BATCH_ID | NUMBER | Batch identifier generated during pre-processing | ||
| SELLER_FLAG | VARCHAR2 | (30) | Seller Flag |
Cut, paste (and edit) the following text to query this object:
SELECT DESIGNATOR_ID
, DESIGNATOR
, SR_DESIGNATOR
, ORGANIZATION_ID
, SR_ORGANIZATION_ID
, MPS_RELIEF
, INVENTORY_ATP_FLAG
, DESCRIPTION
, DISABLE_DATE
, DEMAND_CLASS
, ORGANIZATION_SELECTION
, PRODUCTION
, RECOMMENDATION_RELEASE
, DESIGNATOR_TYPE
, 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
, CONSUME_FORECAST
, UPDATE_TYPE
, FORWARD_UPDATE_TIME_FENCE
, BACKWARD_UPDATE_TIME_FENCE
, OUTLIER_UPDATE_PERCENTAGE
, FORECAST_SET_ID
, CUSTOMER_ID
, SHIP_ID
, BILL_ID
, BUCKET_TYPE
, PROBABILITY
, FORECAST_SET
, COMPANY_ID
, COMPANY_NAME
, ORGANIZATION_CODE
, CUSTOMER_NAME
, SHIP_TO_SITE_CODE
, BILL_TO_SITE_CODE
, SR_INSTANCE_CODE
, MESSAGE_ID
, PROCESS_FLAG
, DATA_SOURCE_TYPE
, ST_TRANSACTION_ID
, ERROR_TEXT
, BATCH_ID
, SELLER_FLAG
FROM MSC.MSC_ST_DESIGNATORS;
MSC.MSC_ST_DESIGNATORS does not reference any database object
MSC.MSC_ST_DESIGNATORS is referenced by following:
APPS
MSC_ST_DESIGNATORS
|
|
|
|