FND Design Data [Home] [Help]

View: MRP_PF_ATP_ITEMS_ALL_V

Product: MRP - Master Scheduling/MRP
Description: This view is used for ATP and derived from MTL_DEMAND_INTERFACE
Implementation/DBA Data: ViewAPPS.MRP_PF_ATP_ITEMS_ALL_V
View Text

SELECT DISTINCT V.ATP_GROUP_ID
, V.ORGANIZATION_ID
, V.INVENTORY_ITEM_ID
, V.ATP_RULE_ID
, V.AVAILABLE_TO_ATP
, V.ATP_CALENDAR_ORGANIZATION_ID
, V.N_COLUMN1
, V.DEMAND_CLASS
FROM MRP_PF_ATP_V V

Columns

Name
ATP_GROUP_ID
ORGANIZATION_ID
INVENTORY_ITEM_ID
ATP_RULE_ID
AVAILABLE_TO_ATP
ATP_CALENDAR_ORGANIZATION_ID
N_COLUMN1
DEMAND_CLASS