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: APPS.MRP_ATP_PROPERTIES_V

Object Details

Object Name:	MRP_ATP_PROPERTIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	MRP.MRP_ATP_PROPERTIES_V
Subobject Name:
Status:	VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
SESSION_ID	NUMBER		Yes	ATP session identifier
PEGGING_ID	NUMBER			ATP Pegging identifier
FIXED_LEAD_TIME	NUMBER			Fixed Lead Time
VARIABLE_LEAD_TIME	NUMBER			Variable Lead Time
PREPROCESSING_LEAD_TIME	NUMBER			Preprocessing Lead Time
PROCESSING_LEAD_TIME	NUMBER			Processing Lead Time
POSTPROCESSING_LEAD_TIME	NUMBER			Postprocessing Lead Time
INTRANSIT_LEAD_TIME	NUMBER			Intransit Lead Time
SHIP_METHOD	VARCHAR2	(30)		Ship Method
PTF_DATE	DATE			Planning Time Fence Date
REQUIRED_QUANTITY	NUMBER			Qty required
REQUIRED_DATE	DATE			Required Date
ATP_RULE	VARCHAR2	(80)		ATP Rule
INFINITE_TIME_FENCE	DATE			Instransit Time Fence
SUBSTITUTION_WINDOW	NUMBER			Substitution Window
ROUNDING_CONTROL	VARCHAR2	(80)		Rounding Control settings
WEIGHT_CAPACITY	NUMBER			Weight
VOLUME_CAPACITY	NUMBER			Volume Capacity
ATP_FLAG	VARCHAR2	(80)		ATP Flag attribute
ATP_COMPONENT_FLAG	VARCHAR2	(80)		ATP Component Flag Attribute
OPERATION_SEQUENCE_ID	NUMBER			Routing Operation sequence
USAGE	NUMBER			Usage
OFFSET	NUMBER			Offset
EFFICIENCY	NUMBER			Efficiency
UTILIZATION	NUMBER			Utilization
OWNING_DEPARTMENT	VARCHAR2	(10)		Owning department
REVERSE_CUM_YIELD	NUMBER			Reverse Cumulative Yield
BASIS_TYPE	VARCHAR2	(4000)		Basis Type
BATCH_FLAG	VARCHAR2	(80)		Batch Flag
ALLOCATION_RULE	VARCHAR2	(30)		Allocation Rule
PLAN_NAME	VARCHAR2	(10)		Plan Name
VOLUME_UOM	VARCHAR2	(3)		Volume Unit of Measure
WEIGHT_UOM	VARCHAR2	(3)		Weight Unit of Measure
ATF_DATE	DATE
COMPONENT_YIELD_FACTOR	NUMBER
ROUNDING_DIRECTION	NUMBER
SCALING_TYPE	VARCHAR2	(4000)
SCALE_ROUNDING_VARIANCE	NUMBER
SCALE_MULTIPLE	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SESSION_ID
,      PEGGING_ID
,      FIXED_LEAD_TIME
,      VARIABLE_LEAD_TIME
,      PREPROCESSING_LEAD_TIME
,      PROCESSING_LEAD_TIME
,      POSTPROCESSING_LEAD_TIME
,      INTRANSIT_LEAD_TIME
,      SHIP_METHOD
,      PTF_DATE
,      REQUIRED_QUANTITY
,      REQUIRED_DATE
,      ATP_RULE
,      INFINITE_TIME_FENCE
,      SUBSTITUTION_WINDOW
,      ROUNDING_CONTROL
,      WEIGHT_CAPACITY
,      VOLUME_CAPACITY
,      ATP_FLAG
,      ATP_COMPONENT_FLAG
,      OPERATION_SEQUENCE_ID
,      USAGE
,      OFFSET
,      EFFICIENCY
,      UTILIZATION
,      OWNING_DEPARTMENT
,      REVERSE_CUM_YIELD
,      BASIS_TYPE
,      BATCH_FLAG
,      ALLOCATION_RULE
,      PLAN_NAME
,      VOLUME_UOM
,      WEIGHT_UOM
,      ATF_DATE
,      COMPONENT_YIELD_FACTOR
,      ROUNDING_DIRECTION
,      SCALING_TYPE
,      SCALE_ROUNDING_VARIANCE
,      SCALE_MULTIPLE
FROM APPS.MRP_ATP_PROPERTIES_V;

Dependencies

[top of page]

APPS.MRP_ATP_PROPERTIES_V references the following:

APPS: FND_COMMON_LOOKUPS; FND_GLOBAL - show dependent code; MFG_LOOKUPS; MRP_ATP_DETAILS_TEMP; MRP_GET_PROJECT - show dependent code

APPS.MRP_ATP_PROPERTIES_V is not referenced by any database object