VIEW: MSD.MSD_ST_ITEM_RELATIONSHIPS#

Source

View Text - Preformatted

select INSTANCE_ID INSTANCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, INVENTORY_ITEM INVENTORY_ITEM, RELATED_ITEM_ID RELATED_ITEM_ID, RELATED_ITEM RELATED_ITEM, RELATIONSHIP_TYPE_ID RELATIONSHIP_TYPE_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, SR_INSTANCE_CODE SR_INSTANCE_CODE, RELATIONSHIP_TYPE RELATIONSHIP_TYPE, BATCH_ID BATCH_ID, ST_TRANSACTION_ID ST_TRANSACTION_ID, PROCESS_FLAG PROCESS_FLAG, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ERROR_TEXT ERROR_TEXT, MESSAGE_ID MESSAGE_ID, START_DATE START_DATE, END_DATE END_DATE from "MSD"."MSD_ST_ITEM_RELATIONSHIPS"

View Text - HTML Formatted

SELECT INSTANCE_ID INSTANCE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, INVENTORY_ITEM INVENTORY_ITEM
, RELATED_ITEM_ID RELATED_ITEM_ID
, RELATED_ITEM RELATED_ITEM
, RELATIONSHIP_TYPE_ID RELATIONSHIP_TYPE_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
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, RELATIONSHIP_TYPE RELATIONSHIP_TYPE
, BATCH_ID BATCH_ID
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, PROCESS_FLAG PROCESS_FLAG
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ERROR_TEXT ERROR_TEXT
, MESSAGE_ID MESSAGE_ID
, START_DATE START_DATE
, END_DATE END_DATE
FROM "MSD"."MSD_ST_ITEM_RELATIONSHIPS"