VIEW: MRP.MRP_AD_TXN_REQUEST_LINES#

Source

View Text - Preformatted

select TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID, TXN_SOURCE_ID TXN_SOURCE_ID, TASK_ID TASK_ID, PROJECT_ID PROJECT_ID, 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, HEADER_ID HEADER_ID, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID from "MRP"."MRP_AD_TXN_REQUEST_LINES"

View Text - HTML Formatted

SELECT TRANSACTION_SOURCE_TYPE_ID TRANSACTION_SOURCE_TYPE_ID
, TXN_SOURCE_ID TXN_SOURCE_ID
, TASK_ID TASK_ID
, PROJECT_ID PROJECT_ID
, 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
, HEADER_ID HEADER_ID
, TRANSACTION_TYPE_ID TRANSACTION_TYPE_ID
FROM "MRP"."MRP_AD_TXN_REQUEST_LINES"