VIEW: MSC.MSC_ATP_PEGGING#

Source

View Text - Preformatted

select PLAN_ID PLAN_ID, SR_INSTANCE_ID SR_INSTANCE_ID, REFERENCE_ITEM_ID REFERENCE_ITEM_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, SALES_ORDER_LINE_ID SALES_ORDER_LINE_ID, BOM_ITEM_TYPE BOM_ITEM_TYPE, SALES_ORDER_QTY SALES_ORDER_QTY, TRANSACTION_DATE TRANSACTION_DATE, DEMAND_ID DEMAND_ID, DEMAND_QUANTITY DEMAND_QUANTITY, DISPOSITION_ID DISPOSITION_ID, DEMAND_CLASS DEMAND_CLASS, CONSUMED_QTY CONSUMED_QTY, OVERCONSUMPTION_QTY OVERCONSUMPTION_QTY, SUPPLY_ID SUPPLY_ID, SUPPLY_QUANTITY SUPPLY_QUANTITY, ALLOCATED_QUANTITY ALLOCATED_QUANTITY, RESOURCE_ID RESOURCE_ID, DEPARTMENT_ID DEPARTMENT_ID, RESOURCE_HOURS RESOURCE_HOURS, DAILY_RESOURCE_HOURS DAILY_RESOURCE_HOURS, START_DATE START_DATE, END_DATE END_DATE, RELIEF_TYPE RELIEF_TYPE, RELIEF_QUANTITY RELIEF_QUANTITY, DAILY_RELIEF_QTY DAILY_RELIEF_QTY, PEGGING_ID PEGGING_ID, PREV_PEGGING_ID PREV_PEGGING_ID, END_PEGGING_ID END_PEGGING_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CUSTOMER_ID CUSTOMER_ID, CUSTOMER_SITE_ID CUSTOMER_SITE_ID, DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE, END_DEMAND_ID END_DEMAND_ID, ORIGINAL_ITEM_ID ORIGINAL_ITEM_ID, ORIGINAL_DATE ORIGINAL_DATE, OFFSET_SUPPLY_ID OFFSET_SUPPLY_ID, OFFSET_TYPE OFFSET_TYPE from "MSC"."MSC_ATP_PEGGING"

View Text - HTML Formatted

SELECT PLAN_ID PLAN_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, REFERENCE_ITEM_ID REFERENCE_ITEM_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SALES_ORDER_LINE_ID SALES_ORDER_LINE_ID
, BOM_ITEM_TYPE BOM_ITEM_TYPE
, SALES_ORDER_QTY SALES_ORDER_QTY
, TRANSACTION_DATE TRANSACTION_DATE
, DEMAND_ID DEMAND_ID
, DEMAND_QUANTITY DEMAND_QUANTITY
, DISPOSITION_ID DISPOSITION_ID
, DEMAND_CLASS DEMAND_CLASS
, CONSUMED_QTY CONSUMED_QTY
, OVERCONSUMPTION_QTY OVERCONSUMPTION_QTY
, SUPPLY_ID SUPPLY_ID
, SUPPLY_QUANTITY SUPPLY_QUANTITY
, ALLOCATED_QUANTITY ALLOCATED_QUANTITY
, RESOURCE_ID RESOURCE_ID
, DEPARTMENT_ID DEPARTMENT_ID
, RESOURCE_HOURS RESOURCE_HOURS
, DAILY_RESOURCE_HOURS DAILY_RESOURCE_HOURS
, START_DATE START_DATE
, END_DATE END_DATE
, RELIEF_TYPE RELIEF_TYPE
, RELIEF_QUANTITY RELIEF_QUANTITY
, DAILY_RELIEF_QTY DAILY_RELIEF_QTY
, PEGGING_ID PEGGING_ID
, PREV_PEGGING_ID PREV_PEGGING_ID
, END_PEGGING_ID END_PEGGING_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CUSTOMER_ID CUSTOMER_ID
, CUSTOMER_SITE_ID CUSTOMER_SITE_ID
, DEMAND_SOURCE_TYPE DEMAND_SOURCE_TYPE
, END_DEMAND_ID END_DEMAND_ID
, ORIGINAL_ITEM_ID ORIGINAL_ITEM_ID
, ORIGINAL_DATE ORIGINAL_DATE
, OFFSET_SUPPLY_ID OFFSET_SUPPLY_ID
, OFFSET_TYPE OFFSET_TYPE
FROM "MSC"."MSC_ATP_PEGGING"