VIEW: MRP.MRP_INVENTORY_LOTS#

Source

View Text - Preformatted

select INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, COMPILE_DESIGNATOR COMPILE_DESIGNATOR, INVENTORY_LOT_NUMBER INVENTORY_LOT_NUMBER, 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, LOT_QUANTITY LOT_QUANTITY, LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE, EXPIRED_LOT_QUANTITY EXPIRED_LOT_QUANTITY, LOT_SUB_INVENTORY_CODE LOT_SUB_INVENTORY_CODE, EXPIRED_LOT_ID EXPIRED_LOT_ID, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PLANNING_GROUP PLANNING_GROUP, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER from "MRP"."MRP_INVENTORY_LOTS"

View Text - HTML Formatted

SELECT INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, COMPILE_DESIGNATOR COMPILE_DESIGNATOR
, INVENTORY_LOT_NUMBER INVENTORY_LOT_NUMBER
, 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
, LOT_QUANTITY LOT_QUANTITY
, LOT_EXPIRATION_DATE LOT_EXPIRATION_DATE
, EXPIRED_LOT_QUANTITY EXPIRED_LOT_QUANTITY
, LOT_SUB_INVENTORY_CODE LOT_SUB_INVENTORY_CODE
, EXPIRED_LOT_ID EXPIRED_LOT_ID
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PLANNING_GROUP PLANNING_GROUP
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
FROM "MRP"."MRP_INVENTORY_LOTS"