VIEW: MSC.MSC_ST_SR_SOURCE_ORG#

Source

View Text - Preformatted

select SR_SOURCE_ID SR_SOURCE_ID, SR_SR_SOURCE_ID SR_SR_SOURCE_ID, SR_RECEIPT_ID SR_RECEIPT_ID, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_PARTNER_ID SOURCE_PARTNER_ID, SOURCE_PARTNER_SITE_ID SOURCE_PARTNER_SITE_ID, SECONDARY_INVENTORY SECONDARY_INVENTORY, SOURCE_TYPE SOURCE_TYPE, ALLOCATION_PERCENT ALLOCATION_PERCENT, RANK RANK, VENDOR_NAME VENDOR_NAME, VENDOR_SITE_CODE VENDOR_SITE_CODE, SHIP_METHOD SHIP_METHOD, DELETED_FLAG DELETED_FLAG, 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_ID SR_INSTANCE_ID, REFRESH_ID REFRESH_ID, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID from "MSC"."MSC_ST_SR_SOURCE_ORG"

View Text - HTML Formatted

SELECT SR_SOURCE_ID SR_SOURCE_ID
, SR_SR_SOURCE_ID SR_SR_SOURCE_ID
, SR_RECEIPT_ID SR_RECEIPT_ID
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_PARTNER_ID SOURCE_PARTNER_ID
, SOURCE_PARTNER_SITE_ID SOURCE_PARTNER_SITE_ID
, SECONDARY_INVENTORY SECONDARY_INVENTORY
, SOURCE_TYPE SOURCE_TYPE
, ALLOCATION_PERCENT ALLOCATION_PERCENT
, RANK RANK
, VENDOR_NAME VENDOR_NAME
, VENDOR_SITE_CODE VENDOR_SITE_CODE
, SHIP_METHOD SHIP_METHOD
, DELETED_FLAG DELETED_FLAG
, 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_ID SR_INSTANCE_ID
, REFRESH_ID REFRESH_ID
, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID
FROM "MSC"."MSC_ST_SR_SOURCE_ORG"