VIEW: MSC.MSC_ST_ITEM_SOURCING#

Source

View Text - Preformatted

select SR_SOURCE_ID SR_SOURCE_ID, SR_RECEIPT_ID SR_RECEIPT_ID, REFRESH_ID REFRESH_ID, ASSIGNMENT_ID ASSIGNMENT_ID, SOURCING_RULE_ID SOURCING_RULE_ID, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID, CATEGORY_ID CATEGORY_ID, CATEGORY_SET_ID CATEGORY_SET_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, SR_INSTANCE_ID SR_INSTANCE_ID, RECEIPT_ORGANIZATION_ID RECEIPT_ORGANIZATION_ID, RECEIPT_ORG_INSTANCE_ID RECEIPT_ORG_INSTANCE_ID, EFFECTIVE_DATE EFFECTIVE_DATE, DISABLE_DATE DISABLE_DATE, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID, SOURCE_PARTNER_ID SOURCE_PARTNER_ID, SOURCE_PARTNER_SITE_ID SOURCE_PARTNER_SITE_ID, ALLOCATION_PERCENT ALLOCATION_PERCENT, RANK RANK, SOURCE_TYPE SOURCE_TYPE, DESCRIPTION DESCRIPTION, PLANNING_ACTIVE PLANNING_ACTIVE, SHIP_METHOD SHIP_METHOD, ASSIGNMENT_TYPE ASSIGNMENT_TYPE, ITEM_NAME ITEM_NAME, CATEGORY_NAME CATEGORY_NAME, ORGANIZATION_CODE ORGANIZATION_CODE, SR_INSTANCE_CODE SR_INSTANCE_CODE, RECEIPT_ORGANIZATION_CODE RECEIPT_ORGANIZATION_CODE, RECEIPT_ORG_INSTANCE_CODE RECEIPT_ORG_INSTANCE_CODE, SOURCE_ORGANIZATION_CODE SOURCE_ORGANIZATION_CODE, SOURCE_ORG_INSTANCE_CODE SOURCE_ORG_INSTANCE_CODE, SOURCE_PARTNER_NAME SOURCE_PARTNER_NAME, SOURCE_PARTNER_SITE_CODE SOURCE_PARTNER_SITE_CODE, SOURCING_RULE_NAME SOURCING_RULE_NAME, ASSIGNMENT_SET_NAME ASSIGNMENT_SET_NAME, DELETED_FLAG DELETED_FLAG, MESSAGE_ID MESSAGE_ID, ERROR_TEXT ERROR_TEXT, PROCESS_FLAG PROCESS_FLAG, BATCH_ID BATCH_ID, DATA_SOURCE_TYPE DATA_SOURCE_TYPE, ST_TRANSACTION_ID ST_TRANSACTION_ID, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, 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, COMPANY_NAME COMPANY_NAME, COMPANY_ID COMPANY_ID, SOURCE_ORG_ID SOURCE_ORG_ID, SOURCE_RECEIPT_ORGANIZATION_ID SOURCE_RECEIPT_ORGANIZATION_ID, SOURCE_INVENTORY_ITEM_ID SOURCE_INVENTORY_ITEM_ID, SOURCE_CATEGORY_SET_ID SOURCE_CATEGORY_SET_ID, SOURCE_CATEGORY_ID SOURCE_CATEGORY_ID, SOURCE_SOURCE_PARTNER_ID SOURCE_SOURCE_PARTNER_ID, SOURCE_SOURCE_PARTNER_SITE_ID SOURCE_SOURCE_PARTNER_SITE_ID, SOURCE_SOURCE_ORGANIZATION_ID SOURCE_SOURCE_ORGANIZATION_ID, SOURCE_SOURCING_RULE_ID SOURCE_SOURCING_RULE_ID, SOURCE_ASSIGNMENT_SET_ID SOURCE_ASSIGNMENT_SET_ID, SOURCE_SR_RECEIPT_ID SOURCE_SR_RECEIPT_ID, SOURCE_SR_SOURCE_ID SOURCE_SR_SOURCE_ID, SOURCE_ASSIGNMENT_ID SOURCE_ASSIGNMENT_ID from "MSC"."MSC_ST_ITEM_SOURCING"

View Text - HTML Formatted

SELECT SR_SOURCE_ID SR_SOURCE_ID
, SR_RECEIPT_ID SR_RECEIPT_ID
, REFRESH_ID REFRESH_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, SOURCING_RULE_ID SOURCING_RULE_ID
, ASSIGNMENT_SET_ID ASSIGNMENT_SET_ID
, CATEGORY_ID CATEGORY_ID
, CATEGORY_SET_ID CATEGORY_SET_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, SR_INSTANCE_ID SR_INSTANCE_ID
, RECEIPT_ORGANIZATION_ID RECEIPT_ORGANIZATION_ID
, RECEIPT_ORG_INSTANCE_ID RECEIPT_ORG_INSTANCE_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, DISABLE_DATE DISABLE_DATE
, SOURCE_ORGANIZATION_ID SOURCE_ORGANIZATION_ID
, SOURCE_ORG_INSTANCE_ID SOURCE_ORG_INSTANCE_ID
, SOURCE_PARTNER_ID SOURCE_PARTNER_ID
, SOURCE_PARTNER_SITE_ID SOURCE_PARTNER_SITE_ID
, ALLOCATION_PERCENT ALLOCATION_PERCENT
, RANK RANK
, SOURCE_TYPE SOURCE_TYPE
, DESCRIPTION DESCRIPTION
, PLANNING_ACTIVE PLANNING_ACTIVE
, SHIP_METHOD SHIP_METHOD
, ASSIGNMENT_TYPE ASSIGNMENT_TYPE
, ITEM_NAME ITEM_NAME
, CATEGORY_NAME CATEGORY_NAME
, ORGANIZATION_CODE ORGANIZATION_CODE
, SR_INSTANCE_CODE SR_INSTANCE_CODE
, RECEIPT_ORGANIZATION_CODE RECEIPT_ORGANIZATION_CODE
, RECEIPT_ORG_INSTANCE_CODE RECEIPT_ORG_INSTANCE_CODE
, SOURCE_ORGANIZATION_CODE SOURCE_ORGANIZATION_CODE
, SOURCE_ORG_INSTANCE_CODE SOURCE_ORG_INSTANCE_CODE
, SOURCE_PARTNER_NAME SOURCE_PARTNER_NAME
, SOURCE_PARTNER_SITE_CODE SOURCE_PARTNER_SITE_CODE
, SOURCING_RULE_NAME SOURCING_RULE_NAME
, ASSIGNMENT_SET_NAME ASSIGNMENT_SET_NAME
, DELETED_FLAG DELETED_FLAG
, MESSAGE_ID MESSAGE_ID
, ERROR_TEXT ERROR_TEXT
, PROCESS_FLAG PROCESS_FLAG
, BATCH_ID BATCH_ID
, DATA_SOURCE_TYPE DATA_SOURCE_TYPE
, ST_TRANSACTION_ID ST_TRANSACTION_ID
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, 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
, COMPANY_NAME COMPANY_NAME
, COMPANY_ID COMPANY_ID
, SOURCE_ORG_ID SOURCE_ORG_ID
, SOURCE_RECEIPT_ORGANIZATION_ID SOURCE_RECEIPT_ORGANIZATION_ID
, SOURCE_INVENTORY_ITEM_ID SOURCE_INVENTORY_ITEM_ID
, SOURCE_CATEGORY_SET_ID SOURCE_CATEGORY_SET_ID
, SOURCE_CATEGORY_ID SOURCE_CATEGORY_ID
, SOURCE_SOURCE_PARTNER_ID SOURCE_SOURCE_PARTNER_ID
, SOURCE_SOURCE_PARTNER_SITE_ID SOURCE_SOURCE_PARTNER_SITE_ID
, SOURCE_SOURCE_ORGANIZATION_ID SOURCE_SOURCE_ORGANIZATION_ID
, SOURCE_SOURCING_RULE_ID SOURCE_SOURCING_RULE_ID
, SOURCE_ASSIGNMENT_SET_ID SOURCE_ASSIGNMENT_SET_ID
, SOURCE_SR_RECEIPT_ID SOURCE_SR_RECEIPT_ID
, SOURCE_SR_SOURCE_ID SOURCE_SR_SOURCE_ID
, SOURCE_ASSIGNMENT_ID SOURCE_ASSIGNMENT_ID
FROM "MSC"."MSC_ST_ITEM_SOURCING"