View: MRP_SR_SOURCE_ORG_V

Product:	MRP - Master Scheduling/MRP
Description:	Sourcing rule source organization view
Implementation/DBA Data:	APPS.MRP_SR_SOURCE_ORG_V

View Text

SELECT DISTINCT S.ROWID
, S.SR_SOURCE_ID
, S.SR_RECEIPT_ID
, S.SOURCE_ORGANIZATION_ID
, O.ORGANIZATION_CODE
, S.VENDOR_ID
, V.VENDOR_NAME
, S.VENDOR_SITE_ID
, VS.VENDOR_SITE_CODE
, 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 MRP_SR_SOURCE_ORG S
, PO_VENDORS V
, PO_VENDOR_SITES_ALL VS
, MTL_PARAMETERS O
, MTL_INTERORG_SHIP_METHODS SM
WHERE V.VENDOR_ID (+) = S.VENDOR_ID
AND VS.VENDOR_SITE_ID (+) = S.VENDOR_SITE_ID
AND O.ORGANIZATION_ID (+) = S.SOURCE_ORGANIZATION_ID
AND SM.SHIP_METHOD (+) = S.SHIP_METHOD
AND ((S.SHIP_METHOD IS NULL) OR (SM.FROM_ORGANIZATION_ID = S.SOURCE_ORGANIZATION_ID
AND SM.TO_ORGANIZATION_ID = (SELECT RECEIPT_ORGANIZATION_ID
FROM MRP_SR_RECEIPT_ORG
WHERE SR_RECEIPT_ID = S.SR_RECEIPT_ID)))

Columns