VIEW: MRP.MRP_AD_MTRX_TMP#

Source

View Text - Preformatted

select TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID, TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID, RCV_TRANSACTION_ID RCV_TRANSACTION_ID, POSTING_FLAG POSTING_FLAG, TASK_ID TASK_ID, PROJECT_ID PROJECT_ID, SUBINVENTORY_CODE SUBINVENTORY_CODE, ORGANIZATION_ID ORGANIZATION_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, RN RN, PRIMARY_QUANTITY PRIMARY_QUANTITY, OWNING_ORGANIZATION_ID OWNING_ORGANIZATION_ID, OWNING_TP_TYPE OWNING_TP_TYPE, PLANNING_ORGANIZATION_ID PLANNING_ORGANIZATION_ID, PLANNING_TP_TYPE PLANNING_TP_TYPE, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER, TRANSACTION_ID TRANSACTION_ID from "MRP"."MRP_AD_MTRX_TMP"

View Text - HTML Formatted

SELECT TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, TRANSACTION_ACTION_ID TRANSACTION_ACTION_ID
, TRANSACTION_SOURCE_ID TRANSACTION_SOURCE_ID
, RCV_TRANSACTION_ID RCV_TRANSACTION_ID
, POSTING_FLAG POSTING_FLAG
, TASK_ID TASK_ID
, PROJECT_ID PROJECT_ID
, SUBINVENTORY_CODE SUBINVENTORY_CODE
, ORGANIZATION_ID ORGANIZATION_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, RN RN
, PRIMARY_QUANTITY PRIMARY_QUANTITY
, OWNING_ORGANIZATION_ID OWNING_ORGANIZATION_ID
, OWNING_TP_TYPE OWNING_TP_TYPE
, PLANNING_ORGANIZATION_ID PLANNING_ORGANIZATION_ID
, PLANNING_TP_TYPE PLANNING_TP_TYPE
, END_ITEM_UNIT_NUMBER END_ITEM_UNIT_NUMBER
, TRANSACTION_ID TRANSACTION_ID
FROM "MRP"."MRP_AD_MTRX_TMP"