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_ITEMS_RESOURCE_V

Object Details

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

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ATP_GROUP_ID	NUMBER			Identifies a group of items and/or resources that will be passed to the ATP function as a group
ORGANIZATION_ID	NUMBER			Organization identifier
INVENTORY_ITEM_ID	NUMBER		Yes	Inventory item identifier
DEPARTMENT_ID	NUMBER			Department identifier
RESOURCE_ID	NUMBER			Resource identifier
LINE_ID	NUMBER			Line identifier
ENTITY_ID	NUMBER			Entity identifier
ATP_RULE_ID	NUMBER			ATP rule identifier
AVAILABLE_TO_ATP	NUMBER			Flag to indicate if the item in the row should be ATP checked
ATP_CALENDAR_ORGANIZATION_ID	NUMBER			Identifier for the organization that ATP will use to get the calendar for ATP computations
N_COLUMN1	NUMBER			Column used to identify record originated from Supply Demand Inquiry
DEMAND_CLASS	VARCHAR2	(30)		Demand class
RESOURCE_BASIS_TYPE	NUMBER			Resource basis type
RESOURCE_USAGE_RATE_OR_AMOUNT	NUMBER			Resource usage rate or amount
RESOURCE_OFFSET_PERCENT	NUMBER			Resource offset percent
AVAILABLE_24_HOURS_FLAG	NUMBER			Flag to show if resource is available 24 hours or by shifts
OPERATION_SEQ_NUM	NUMBER		Yes	Sequence number of the resource operation
OPTION_DEPENDENT_FLAG	NUMBER		Yes	Indicates whether to use this operation in all configuration routings, even if no components of this configuration are used in this operation

Query Text

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


SELECT ATP_GROUP_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      DEPARTMENT_ID
,      RESOURCE_ID
,      LINE_ID
,      ENTITY_ID
,      ATP_RULE_ID
,      AVAILABLE_TO_ATP
,      ATP_CALENDAR_ORGANIZATION_ID
,      N_COLUMN1
,      DEMAND_CLASS
,      RESOURCE_BASIS_TYPE
,      RESOURCE_USAGE_RATE_OR_AMOUNT
,      RESOURCE_OFFSET_PERCENT
,      AVAILABLE_24_HOURS_FLAG
,      OPERATION_SEQ_NUM
,      OPTION_DEPENDENT_FLAG
FROM APPS.MRP_ATP_ITEMS_RESOURCE_V;

Dependencies

[top of page]

APPS.MRP_ATP_ITEMS_RESOURCE_V references the following:

APPS: BOM_CALENDAR_DATES; BOM_DEPARTMENT_RESOURCES; BOM_OPERATIONAL_ROUTINGS; BOM_OPERATION_RESOURCES; BOM_OPERATION_SEQUENCES; MRP_ATP_BASE_V; MTL_PARAMETERS; MTL_UOM_CONVERSIONS

APPS.MRP_ATP_ITEMS_RESOURCE_V is referenced by following:

APPS: MRP_ATP_ITEMS_ALL_V