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