VIEW: APPS.MRP_SR_SOURCE_ORG_V

Source

View Text - Preformatted

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)))

View Text - HTML Formatted

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)))