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

VIEW: APPS.MRP_ATP_ITEMS_ALL_V

Object Details
Object Name: MRP_ATP_ITEMS_ALL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_ATP_ITEMS_ALL_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

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

The 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

Sequence number of the resource operation
OPTION_DEPENDENT_FLAG NUMBER

Indicates whether to use this operation in all configuration routings, even if no components of the 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_ALL_V;

Dependencies

[top of page]

APPS.MRP_ATP_ITEMS_ALL_V references the following:

SchemaAPPS
SynonymBOM_OPERATIONAL_ROUTINGS
ViewMRP_ATP_BASE_V
ViewMRP_ATP_ITEMS_RESOURCE_V

APPS.MRP_ATP_ITEMS_ALL_V is not referenced by any database object