VIEW: APPS.MSC_SR_RECEIPT_ORG_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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