[Home] [Help] [Dependency Information]
Object Name: | MSC_ST_ATP_RULES |
---|---|
Object Type: | TABLE |
Owner: | MSC |
FND Design Data: | MSC.MSC_ST_ATP_RULES |
Subobject Name: | |
Status: | VALID |
The staging table used by the collection program to validate and process data
for table MSC_ATP_RULES.
Tablespace: | APPS_TS_INTERFACE |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RULE_ID | NUMBER | ATP rule identifier | ||
SR_INSTANCE_ID | NUMBER | Instance id | ||
RULE_NAME | VARCHAR2 | (80) | Name of ATP rule | |
DESCRIPTION | VARCHAR2 | (240) | Desscription for ATP rule | |
ACCUMULATE_AVAILABLE_FLAG | NUMBER | Flag for ATP computation to accumulate quantity availability | ||
BACKWARD_CONSUMPTION_FLAG | NUMBER | Flag for ATP computation to backwardly consume shortage | ||
FORWARD_CONSUMPTION_FLAG | NUMBER | Flag for ATP computation to forwardly consume shortage | ||
PAST_DUE_DEMAND_CUTOFF_FENCE | NUMBER | Demand before the specified number of days are not to be considered in ATP computation | ||
PAST_DUE_SUPPLY_CUTOFF_FENCE | NUMBER | Supplies before the specified number of days are not to be considered in ATP computation | ||
INFINITE_SUPPLY_FENCE_CODE | NUMBER | Source code for infinite supply time fence | ||
INFINITE_SUPPLY_TIME_FENCE | NUMBER | Infinite supply time fence days only when user-defined is specified in the time fence code | ||
ACCEPTABLE_EARLY_FENCE | NUMBER | Acceptable early fence | ||
ACCEPTABLE_LATE_FENCE | NUMBER | Acceptable late fence | ||
DEFAULT_ATP_SOURCES | NUMBER | Indicate which subinventories to use for on-hand quantities | ||
INCLUDE_SALES_ORDERS | NUMBER | Yes/No flag for ATP computation to include demand from sales orders | ||
INCLUDE_DISCRETE_WIP_DEMAND | NUMBER | Yes/No flag for ATP computation to include demand from WIP discrete jobs | ||
INCLUDE_REP_WIP_DEMAND | NUMBER | Yes/No flag for ATP computation to include demand from WIP repetitive discrete jobs | ||
INCLUDE_NONSTD_WIP_DEMAND | NUMBER | Yes/No flag for ATP computation to include demand from WIP non-standard jobs' | ||
INCLUDE_DISCRETE_MPS | NUMBER | Yes/No flag for ATP computation to include supply from discrete MPS schedule | ||
INCLUDE_USER_DEFINED_DEMAND | NUMBER | Yes/No flag for ATP computation to include user defined demand | ||
INCLUDE_PURCHASE_ORDERS | NUMBER | Yes/No flag for ATP computation to include supply from purchase orders | ||
INCLUDE_DISCRETE_WIP_RECEIPTS | NUMBER | Yes/No flag for ATP computation to include supply from WIP discrete jobs | ||
INCLUDE_REP_WIP_RECEIPTS | NUMBER | Yes/No flag for ATP computation to include supply from WIP repetitive schedule jobs | ||
INCLUDE_NONSTD_WIP_RECEIPTS | NUMBER | Yes/No flag for ATP computation to include supply from WIP non-standard jobs | ||
INCLUDE_INTERORG_TRANSFERS | NUMBER | Yes/No flag for ATP computation to include supply from inter-organization transfers | ||
INCLUDE_ONHAND_AVAILABLE | NUMBER | Yes/No flag for ATP computation to include supply from on-hand inventory | ||
INCLUDE_USER_DEFINED_SUPPLY | NUMBER | Yes/No flag for ATP computation to include supply from user defined source | ||
ACCUMULATION_WINDOW | NUMBER | Maximum number of days that available supply should be accumulated | ||
INCLUDE_REP_MPS | NUMBER | Yes/No flag for ATP computation to include supply from repetitive MPS schedules | ||
INCLUDE_INTERNAL_REQS | NUMBER | Yes/No flag for ATP computation include from internal requisitions | ||
INCLUDE_SUPPLIER_REQS | NUMBER | Yes/No flag for ATP computation include from internal orders | ||
INCLUDE_INTERNAL_ORDERS | NUMBER | Yes/No flag for ATP computation to include demand from internal orders | ||
INCLUDE_FLOW_SCHEDULE_DEMAND | NUMBER | Yes/No flag for ATP computation to include demand from flow schedule | ||
USER_ATP_SUPPLY_TABLE_NAME | VARCHAR2 | (30) | Not currently used | |
USER_ATP_DEMAND_TABLE_NAME | VARCHAR2 | (30) | Not currently used | |
MPS_DESIGNATOR | VARCHAR2 | (10) | Not currently used | |
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 | ||
REFRESH_ID | NUMBER | Refresh identifier | ||
DEMAND_CLASS_ATP_FLAG | NUMBER | Yes/No flag for ATP computation to consider Demand Class when selecting supply and demand | ||
INCLUDE_FLOW_SCHEDULE_RECEIPTS | NUMBER | Yes/No flag for ATP computation to include supply from repetitive MPS schedules | ||
AGGREGATE_TIME_FENCE_CODE | NUMBER | Source code for aggregate order promising time fence | ||
AGGREGATE_TIME_FENCE | NUMBER | Aggregate time fence days |
Cut, paste (and edit) the following text to query this object:
SELECT RULE_ID
, SR_INSTANCE_ID
, RULE_NAME
, DESCRIPTION
, ACCUMULATE_AVAILABLE_FLAG
, BACKWARD_CONSUMPTION_FLAG
, FORWARD_CONSUMPTION_FLAG
, PAST_DUE_DEMAND_CUTOFF_FENCE
, PAST_DUE_SUPPLY_CUTOFF_FENCE
, INFINITE_SUPPLY_FENCE_CODE
, INFINITE_SUPPLY_TIME_FENCE
, ACCEPTABLE_EARLY_FENCE
, ACCEPTABLE_LATE_FENCE
, DEFAULT_ATP_SOURCES
, INCLUDE_SALES_ORDERS
, INCLUDE_DISCRETE_WIP_DEMAND
, INCLUDE_REP_WIP_DEMAND
, INCLUDE_NONSTD_WIP_DEMAND
, INCLUDE_DISCRETE_MPS
, INCLUDE_USER_DEFINED_DEMAND
, INCLUDE_PURCHASE_ORDERS
, INCLUDE_DISCRETE_WIP_RECEIPTS
, INCLUDE_REP_WIP_RECEIPTS
, INCLUDE_NONSTD_WIP_RECEIPTS
, INCLUDE_INTERORG_TRANSFERS
, INCLUDE_ONHAND_AVAILABLE
, INCLUDE_USER_DEFINED_SUPPLY
, ACCUMULATION_WINDOW
, INCLUDE_REP_MPS
, INCLUDE_INTERNAL_REQS
, INCLUDE_SUPPLIER_REQS
, INCLUDE_INTERNAL_ORDERS
, INCLUDE_FLOW_SCHEDULE_DEMAND
, USER_ATP_SUPPLY_TABLE_NAME
, USER_ATP_DEMAND_TABLE_NAME
, MPS_DESIGNATOR
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, REFRESH_ID
, DEMAND_CLASS_ATP_FLAG
, INCLUDE_FLOW_SCHEDULE_RECEIPTS
, AGGREGATE_TIME_FENCE_CODE
, AGGREGATE_TIME_FENCE
FROM MSC.MSC_ST_ATP_RULES;
MSC.MSC_ST_ATP_RULES does not reference any database object
MSC.MSC_ST_ATP_RULES is referenced by following:
|
|
|