VIEW: MRP.MRP_EXCEPTION_DETAILS#

Source

View Text - Preformatted

select COMPILE_DESIGNATOR COMPILE_DESIGNATOR, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, EXCEPTION_TYPE EXCEPTION_TYPE, 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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, QUANTITY QUANTITY, DATE1 DATE1, DATE2 DATE2, DATE3 DATE3, DATE4 DATE4, NUMBER1 NUMBER1, NUMBER2 NUMBER2, NUMBER3 NUMBER3, NUMBER4 NUMBER4, CHAR1 CHAR1, CHAR2 CHAR2, DEPARTMENT_ID DEPARTMENT_ID, RESOURCE_ID RESOURCE_ID, LINE_ID LINE_ID, EXCEPTION_ID EXCEPTION_ID, SUPPLIER_ID SUPPLIER_ID, SUPPLIER_SITE_ID SUPPLIER_SITE_ID from "MRP"."MRP_EXCEPTION_DETAILS"

View Text - HTML Formatted

SELECT COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, EXCEPTION_TYPE EXCEPTION_TYPE
, 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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, QUANTITY QUANTITY
, DATE1 DATE1
, DATE2 DATE2
, DATE3 DATE3
, DATE4 DATE4
, NUMBER1 NUMBER1
, NUMBER2 NUMBER2
, NUMBER3 NUMBER3
, NUMBER4 NUMBER4
, CHAR1 CHAR1
, CHAR2 CHAR2
, DEPARTMENT_ID DEPARTMENT_ID
, RESOURCE_ID RESOURCE_ID
, LINE_ID LINE_ID
, EXCEPTION_ID EXCEPTION_ID
, SUPPLIER_ID SUPPLIER_ID
, SUPPLIER_SITE_ID SUPPLIER_SITE_ID
FROM "MRP"."MRP_EXCEPTION_DETAILS"