View: MSC_SR_SOURCE_ORG_V

Product:	MSC - Advanced Supply Chain Planning
Description:	Sourcing rule source organization view
Implementation/DBA Data:	APPS.MSC_SR_SOURCE_ORG_V

View Text

SELECT DISTINCT S.ROWID
, S.SR_SOURCE_ID
, S.SR_SR_SOURCE_ID
, S.SR_RECEIPT_ID
, S.SR_INSTANCE_ID
, S.SOURCE_ORGANIZATION_ID
, MSC_GET_NAME.ORG_CODE(S.SOURCE_ORGANIZATION_ID
, S.SOURCE_ORG_INSTANCE_ID)
, S.SOURCE_ORG_INSTANCE_ID
, S.SOURCE_PARTNER_ID
, MSC_GET_NAME.SUPPLIER(S.SOURCE_PARTNER_ID)
, S.SOURCE_PARTNER_SITE_ID
, MSC_GET_NAME.SUPPLIER_SITE(S.SOURCE_PARTNER_SITE_ID)
, S.SOURCE_TYPE
, S.ALLOCATION_PERCENT
, S.RANK
, S.SHIP_METHOD
, SM.INTRANSIT_TIME
, S.LAST_UPDATE_DATE
, S.LAST_UPDATED_BY
, S.CREATION_DATE
, S.CREATED_BY
, S.LAST_UPDATE_LOGIN
, S.REQUEST_ID
, S.PROGRAM_APPLICATION_ID
, S.PROGRAM_ID
, S.PROGRAM_UPDATE_DATE
, S.ATTRIBUTE_CATEGORY
, S.ATTRIBUTE1
, S.ATTRIBUTE2
, S.ATTRIBUTE3
, S.ATTRIBUTE4
, S.ATTRIBUTE5
, S.ATTRIBUTE6
, S.ATTRIBUTE7
, S.ATTRIBUTE8
, S.ATTRIBUTE9
, S.ATTRIBUTE10
, S.ATTRIBUTE11
, S.ATTRIBUTE12
, S.ATTRIBUTE13
, S.ATTRIBUTE14
, S.ATTRIBUTE15
FROM MSC_SR_SOURCE_ORG S
, MSC_INTERORG_SHIP_METHODS SM
WHERE S.SHIP_METHOD = SM.SHIP_METHOD (+)
AND SM.PLAN_ID (+) = -1
AND ((S.SHIP_METHOD IS NULL) OR (SM.FROM_ORGANIZATION_ID = S.SOURCE_ORGANIZATION_ID
AND DECODE(S.SOURCE_TYPE
, 1
, S.SOURCE_ORG_INSTANCE_ID
, 2
, S.SR_INSTANCE_ID
, -1) = DECODE(S.SOURCE_TYPE
, 3
, -1
, SM.SR_INSTANCE_ID)
AND SM.TO_ORGANIZATION_ID = (SELECT SR_RECEIPT_ORG
FROM MSC_SR_RECEIPT_ORG
WHERE SR_RECEIPT_ID = S.SR_RECEIPT_ID)))

Columns