eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: MSC.MSC_ST_ATP_RULES#

Object Details

Object Name:	MSC_ST_ATP_RULES#
Object Type:	VIEW
Owner:	MSC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
RULE_ID	NUMBER
SR_INSTANCE_ID	NUMBER
RULE_NAME	VARCHAR2	(80)
DESCRIPTION	VARCHAR2	(240)
ACCUMULATE_AVAILABLE_FLAG	NUMBER
BACKWARD_CONSUMPTION_FLAG	NUMBER
FORWARD_CONSUMPTION_FLAG	NUMBER
PAST_DUE_DEMAND_CUTOFF_FENCE	NUMBER
PAST_DUE_SUPPLY_CUTOFF_FENCE	NUMBER
INFINITE_SUPPLY_FENCE_CODE	NUMBER
INFINITE_SUPPLY_TIME_FENCE	NUMBER
ACCEPTABLE_EARLY_FENCE	NUMBER
ACCEPTABLE_LATE_FENCE	NUMBER
DEFAULT_ATP_SOURCES	NUMBER
INCLUDE_SALES_ORDERS	NUMBER
INCLUDE_DISCRETE_WIP_DEMAND	NUMBER
INCLUDE_REP_WIP_DEMAND	NUMBER
INCLUDE_NONSTD_WIP_DEMAND	NUMBER
INCLUDE_DISCRETE_MPS	NUMBER
INCLUDE_USER_DEFINED_DEMAND	NUMBER
INCLUDE_PURCHASE_ORDERS	NUMBER
INCLUDE_DISCRETE_WIP_RECEIPTS	NUMBER
INCLUDE_REP_WIP_RECEIPTS	NUMBER
INCLUDE_NONSTD_WIP_RECEIPTS	NUMBER
INCLUDE_INTERORG_TRANSFERS	NUMBER
INCLUDE_ONHAND_AVAILABLE	NUMBER
INCLUDE_USER_DEFINED_SUPPLY	NUMBER
ACCUMULATION_WINDOW	NUMBER
INCLUDE_REP_MPS	NUMBER
INCLUDE_INTERNAL_REQS	NUMBER
INCLUDE_SUPPLIER_REQS	NUMBER
INCLUDE_INTERNAL_ORDERS	NUMBER
INCLUDE_FLOW_SCHEDULE_DEMAND	NUMBER
USER_ATP_SUPPLY_TABLE_NAME	VARCHAR2	(30)
USER_ATP_DEMAND_TABLE_NAME	VARCHAR2	(30)
MPS_DESIGNATOR	VARCHAR2	(10)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
REFRESH_ID	NUMBER
DEMAND_CLASS_ATP_FLAG	NUMBER
INCLUDE_FLOW_SCHEDULE_RECEIPTS	NUMBER
AGGREGATE_TIME_FENCE_CODE	NUMBER
AGGREGATE_TIME_FENCE	NUMBER

Query Text

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#;

Dependencies

[top of page]

MSC.MSC_ST_ATP_RULES# references the following:

MSC: MSC_ST_ATP_RULES

MSC.MSC_ST_ATP_RULES# is referenced by following:

APPS: MSC_ST_ATP_RULES