Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MSC_INSTANCE_ORGS_V |
SELECT Q.QUERY_ID
, I.ROWID
, I.SR_INSTANCE_ID
, I.ORGANIZATION_ID
, Q.CHAR1
, Q.CHAR2
, I.LAST_UPDATE_DATE
, I.LAST_UPDATED_BY
, I.CREATION_DATE
, I.CREATED_BY
, I.LAST_UPDATE_LOGIN
, I.ATTRIBUTE_CATEGORY
, I.ATTRIBUTE1
, I.ATTRIBUTE2
, I.ATTRIBUTE3
, I.ATTRIBUTE4
, I.ATTRIBUTE5
, I.ATTRIBUTE6
, I.ATTRIBUTE7
, I.ATTRIBUTE8
, I.ATTRIBUTE9
, I.ATTRIBUTE10
, I.ATTRIBUTE11
, I.ATTRIBUTE12
, I.ATTRIBUTE13
, I.ATTRIBUTE14
, I.ATTRIBUTE15
, I.ENABLED_FLAG
FROM MSC_FORM_QUERY Q
, MSC_INSTANCE_ORGS I
WHERE I.ORGANIZATION_ID = Q.NUMBER1