VIEW: APPS.MRP_ATP_ITEMS_ALL_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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