VIEW: APPS.MSC_INSTANCE_ORGS_V

Source

View Text - Preformatted

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, i.org_group, nvl(i.dp_enabled_flag, i.enabled_flag), nvl(i.ORGANIZATION_TYPE, 1) from msc_form_query q, msc_instance_orgs i WHERE i.organization_id = q.number1

View Text - HTML Formatted

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
, I.ORG_GROUP
, NVL(I.DP_ENABLED_FLAG
, I.ENABLED_FLAG)
, NVL(I.ORGANIZATION_TYPE
, 1)
FROM MSC_FORM_QUERY Q
, MSC_INSTANCE_ORGS I
WHERE I.ORGANIZATION_ID = Q.NUMBER1