Product: | MRP - Master Scheduling/MRP |
---|---|
Description: | Sourcing rule receipt organization view |
Implementation/DBA Data: | APPS.MRP_SR_RECEIPT_ORG_V |
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