Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MSC_PLAN_ORGS_V |
SELECT MPO.ROWID
, MPO.PLAN_ID
, MPO.SR_INSTANCE_ID
, MP.ORGANIZATION_ID
, MP.SR_INSTANCE_ID
, MP.COMPILE_DESIGNATOR
, MPO.ORGANIZATION_ID
, PT.ORGANIZATION_CODE
, PT.PARTNER_NAME
, MPO.PLAN_LEVEL
, MPO.LAST_UPDATED_BY
, MPO.LAST_UPDATE_DATE
, MPO.CREATED_BY
, MPO.CREATION_DATE
, MPO.LAST_UPDATE_LOGIN
, MPO.NET_WIP
, MPO.NET_RESERVATIONS
, MPO.NET_PURCHASING
, MPO.PLAN_SAFETY_STOCK
, MPO.REQUEST_ID
, MPO.PROGRAM_APPLICATION_ID
, MPO.PROGRAM_ID
, MPO.PROGRAM_UPDATE_DATE
, MPO.ATTRIBUTE_CATEGORY
, MPO.ATTRIBUTE1
, MPO.ATTRIBUTE2
, MPO.ATTRIBUTE3
, MPO.ATTRIBUTE4
, MPO.ATTRIBUTE5
, MPO.ATTRIBUTE6
, MPO.ATTRIBUTE7
, MPO.ATTRIBUTE8
, MPO.ATTRIBUTE9
, MPO.ATTRIBUTE10
, MPO.ATTRIBUTE11
, MPO.ATTRIBUTE12
, MPO.ATTRIBUTE13
, MPO.ATTRIBUTE14
, MPO.ATTRIBUTE15
, MPO.SIMULATION_SET
, MPO.BILL_OF_RESOURCES
, MPO.INCLUDE_SALESORDER
FROM MSC_TRADING_PARTNERS PT
, MSC_PLANS MP
, MSC_PLAN_ORGANIZATIONS MPO
WHERE MPO.PLAN_ID = MP.PLAN_ID
AND MPO.SR_INSTANCE_ID = PT.SR_INSTANCE_ID
AND MPO.ORGANIZATION_ID = PT.SR_TP_ID
AND PT.PARTNER_TYPE =3