VIEW: GMP.MR_ACTN_TBL#

Source

View Text - Preformatted

select MRP_ID MRP_ID, ACTION_NO ACTION_NO, ITEM_ID ITEM_ID, WHSE_CODE WHSE_CODE, EVENT_DATE EVENT_DATE, INVENTORY_DATE INVENTORY_DATE, DOC_TYPE DOC_TYPE, DOC_ID DOC_ID, MESSAGE_CODE MESSAGE_CODE, FORMULA_ID FORMULA_ID, MRP_MSG_IND MRP_MSG_IND, PROJ_BALANCE_QTY PROJ_BALANCE_QTY, ACTION_QTY ACTION_QTY, WHSE_CODE_2 WHSE_CODE_2, NET_REQ_ACTION_REF NET_REQ_ACTION_REF, ORGN_CODE ORGN_CODE, STATUS_IND STATUS_IND, LAST_UPDATED_BY LAST_UPDATED_BY, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATION_DATE CREATION_DATE, 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, FMEFF_ID FMEFF_ID from "GMP"."MR_ACTN_TBL"

View Text - HTML Formatted

SELECT MRP_ID MRP_ID
, ACTION_NO ACTION_NO
, ITEM_ID ITEM_ID
, WHSE_CODE WHSE_CODE
, EVENT_DATE EVENT_DATE
, INVENTORY_DATE INVENTORY_DATE
, DOC_TYPE DOC_TYPE
, DOC_ID DOC_ID
, MESSAGE_CODE MESSAGE_CODE
, FORMULA_ID FORMULA_ID
, MRP_MSG_IND MRP_MSG_IND
, PROJ_BALANCE_QTY PROJ_BALANCE_QTY
, ACTION_QTY ACTION_QTY
, WHSE_CODE_2 WHSE_CODE_2
, NET_REQ_ACTION_REF NET_REQ_ACTION_REF
, ORGN_CODE ORGN_CODE
, STATUS_IND STATUS_IND
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATION_DATE CREATION_DATE
, 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
, FMEFF_ID FMEFF_ID
FROM "GMP"."MR_ACTN_TBL"