VIEW: MRP.MRP_FULL_PEGGING#

Source

View Text - Preformatted

select PEGGING_ID PEGGING_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, COMPILE_DESIGNATOR COMPILE_DESIGNATOR, DEMAND_ID DEMAND_ID, DEMAND_QUANTITY DEMAND_QUANTITY, TRANSACTION_ID TRANSACTION_ID, SUPPLY_QUANTITY SUPPLY_QUANTITY, ALLOCATED_QUANTITY ALLOCATED_QUANTITY, PREV_PEGGING_ID PREV_PEGGING_ID, DEMAND_CLASS DEMAND_CLASS, UPDATED UPDATED, STATUS STATUS, END_ITEM_USAGE END_ITEM_USAGE, END_PEGGING_ID END_PEGGING_ID, DEMAND_DATE DEMAND_DATE, SUPPLY_DATE SUPPLY_DATE, SUPPLY_TYPE SUPPLY_TYPE, DISPOSITION_ID DISPOSITION_ID, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, END_ORIGINATION_TYPE END_ORIGINATION_TYPE, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER from "MRP"."MRP_FULL_PEGGING"

View Text - HTML Formatted

SELECT PEGGING_ID PEGGING_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, DEMAND_ID DEMAND_ID
, DEMAND_QUANTITY DEMAND_QUANTITY
, TRANSACTION_ID TRANSACTION_ID
, SUPPLY_QUANTITY SUPPLY_QUANTITY
, ALLOCATED_QUANTITY ALLOCATED_QUANTITY
, PREV_PEGGING_ID PREV_PEGGING_ID
, DEMAND_CLASS DEMAND_CLASS
, UPDATED UPDATED
, STATUS STATUS
, END_ITEM_USAGE END_ITEM_USAGE
, END_PEGGING_ID END_PEGGING_ID
, DEMAND_DATE DEMAND_DATE
, SUPPLY_DATE SUPPLY_DATE
, SUPPLY_TYPE SUPPLY_TYPE
, DISPOSITION_ID DISPOSITION_ID
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, END_ORIGINATION_TYPE END_ORIGINATION_TYPE
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
FROM "MRP"."MRP_FULL_PEGGING"