DBA Data[Home] [Help]
Skip to content

VIEW: MRP.MRP_ERO_RELEASE#

Source

View Text - Preformatted

select TRANSACTION_ID TRANSACTION_ID, REPAIR_SUPPLIER_ID REPAIR_SUPPLIER_ID, REPAIR_SUPPLIER_ORG_ID REPAIR_SUPPLIER_ORG_ID, REPAIR_PROGRAM REPAIR_PROGRAM, BATCH_ID BATCH_ID, DESTINATION_ORG_ID DESTINATION_ORG_ID, SOURCE_ORG_ID SOURCE_ORG_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, PROMISE_DATE PROMISE_DATE, QUANTITY QUANTITY, DEFECTIVE_ITEM_ID DEFECTIVE_ITEM_ID, DEFECTIVE_ITEM_QTY DEFECTIVE_ITEM_QTY from "MRP"."MRP_ERO_RELEASE"
View Text - HTML Formatted

SELECT TRANSACTION_ID TRANSACTION_ID
, REPAIR_SUPPLIER_ID REPAIR_SUPPLIER_ID
, REPAIR_SUPPLIER_ORG_ID REPAIR_SUPPLIER_ORG_ID
, REPAIR_PROGRAM REPAIR_PROGRAM
, BATCH_ID BATCH_ID
, DESTINATION_ORG_ID DESTINATION_ORG_ID
, SOURCE_ORG_ID SOURCE_ORG_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PROMISE_DATE PROMISE_DATE
, QUANTITY QUANTITY
, DEFECTIVE_ITEM_ID DEFECTIVE_ITEM_ID
, DEFECTIVE_ITEM_QTY DEFECTIVE_ITEM_QTY
FROM "MRP"."MRP_ERO_RELEASE"