[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:
|
|
|