Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | ATP all items view |
Implementation/DBA Data: | APPS.MRP_ATP_ITEMS_ALL_V |
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 MRP_ATP_ITEMS_RESOURCE_V UNION ALL SELECT DISTINCT V.ATP_GROUP_ID
, V.ORGANIZATION_ID
, V.INVENTORY_ITEM_ID
, V.OWNING_DEPARTMENT_ID
, V.RESOURCE_ID
, V.LINE_ID
, V.ENTITY_ID
, V.ATP_RULE_ID
, V.AVAILABLE_TO_ATP
, V.ATP_CALENDAR_ORGANIZATION_ID
, V.N_COLUMN1
, V.DEMAND_CLASS
, V.RESOURCE_BASIS_TYPE
, V.RESOURCE_USAGE_RATE_OR_AMOUNT
, TO_NUMBER(NULL)
, V.AVAILABLE_24_HOURS_FLAG
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM MRP_ATP_BASE_V V
WHERE V.ENTITY_ID > 0 UNION ALL SELECT DISTINCT V.ATP_GROUP_ID
, V.ORGANIZATION_ID
, RTG.ASSEMBLY_ITEM_ID
, V.OWNING_DEPARTMENT_ID
, V.RESOURCE_ID
, V.LINE_ID
, V.ENTITY_ID
, V.ATP_RULE_ID
, V.AVAILABLE_TO_ATP
, V.ATP_CALENDAR_ORGANIZATION_ID
, V.N_COLUMN1
, V.DEMAND_CLASS
, V.RESOURCE_BASIS_TYPE
, V.RESOURCE_USAGE_RATE_OR_AMOUNT
, TO_NUMBER(NULL)
, V.AVAILABLE_24_HOURS_FLAG
, TO_NUMBER(NULL)
, TO_NUMBER(NULL)
FROM BOM_OPERATIONAL_ROUTINGS RTG
, MRP_ATP_BASE_V V
WHERE RTG.ORGANIZATION_ID = V.ORGANIZATION_ID
AND RTG.LINE_ID = V.LINE_ID
AND RTG.CTP_FLAG = 1