VIEW: APPS.MRP_SR_RECEIPT_ORG_V

Source

View Text - Preformatted

SELECT S.ROWID , S.SR_RECEIPT_ID , S.SOURCING_RULE_ID , S.RECEIPT_ORGANIZATION_ID , O.ORGANIZATION_CODE , CS.CUSTOMER_NAME , CS.SHIP_TO_ADDRESS , 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 MRP_CUST_SUP_ORG_V CS, MTL_PARAMETERS O, MRP_SR_RECEIPT_ORG S WHERE O.ORGANIZATION_ID (+) = S.RECEIPT_ORGANIZATION_ID AND CS.ORGANIZATION_ID (+) = O.ORGANIZATION_ID

View Text - HTML Formatted

SELECT S.ROWID
, S.SR_RECEIPT_ID
, S.SOURCING_RULE_ID
, S.RECEIPT_ORGANIZATION_ID
, O.ORGANIZATION_CODE
, CS.CUSTOMER_NAME
, CS.SHIP_TO_ADDRESS
, 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 MRP_CUST_SUP_ORG_V CS
, MTL_PARAMETERS O
, MRP_SR_RECEIPT_ORG S
WHERE O.ORGANIZATION_ID (+) = S.RECEIPT_ORGANIZATION_ID
AND CS.ORGANIZATION_ID (+) = O.ORGANIZATION_ID