View: MSC_SR_RECEIPT_ORG_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_SR_RECEIPT_ORG_V

View Text

SELECT S.ROWID
, S.SR_RECEIPT_ID
, S.SR_SR_RECEIPT_ID
, S.SOURCING_RULE_ID
, S.SR_RECEIPT_ORG
, S.RECEIPT_ORG_INSTANCE_ID
, S.SR_INSTANCE_ID
, PT.ORGANIZATION_CODE
, MSC_GET_NAME.CUSTOMER(PT.MODELED_CUSTOMER_ID)
, MSC_GET_NAME.CUSTOMER_SITE(PT.MODELED_CUSTOMER_SITE_ID)
, S.EFFECTIVE_DATE
, S.DISABLE_DATE
, 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_TRADING_PARTNERS PT
, MSC_SR_RECEIPT_ORG S
WHERE S.SR_RECEIPT_ORG = PT.SR_TP_ID(+)
AND S.SR_INSTANCE_ID = PT.SR_INSTANCE_ID (+)
AND 3 = PT.PARTNER_TYPE(+)

Columns