View: QA_PLANS_V

Product:	QA - Quality
Description:	Shows all collection plans
Implementation/DBA Data:	APPS.QA_PLANS_V

View Text

SELECT QP.ROWID ROW_ID
, QP.PLAN_ID
, QP.ORGANIZATION_ID
, QP.LAST_UPDATE_DATE
, QP.LAST_UPDATED_BY
, QP.CREATION_DATE
, QP.CREATED_BY
, QP.LAST_UPDATE_LOGIN
, QP.NAME
, QP.DESCRIPTION
, QP.PLAN_TYPE_CODE
, FL.MEANING PLAN_TYPE_MEANING
, FL.DESCRIPTION PLAN_TYPE_DESCRIPTION
, QP.INSTRUCTIONS
, QP.VIEW_NAME
, QP.IMPORT_VIEW_NAME
, QP.EFFECTIVE_FROM
, QP.EFFECTIVE_TO
, QP.SPEC_ASSIGNMENT_TYPE
, ML3.MEANING SPEC_ASSIGNMENT_MEANING
, QP.ATTRIBUTE_CATEGORY
, QP.ATTRIBUTE1
, QP.ATTRIBUTE2
, QP.ATTRIBUTE3
, QP.ATTRIBUTE4
, QP.ATTRIBUTE5
, QP.ATTRIBUTE6
, QP.ATTRIBUTE7
, QP.ATTRIBUTE8
, QP.ATTRIBUTE9
, QP.ATTRIBUTE10
, QP.ATTRIBUTE11
, QP.ATTRIBUTE12
, QP.ATTRIBUTE13
, QP.ATTRIBUTE14
, QP.ATTRIBUTE15
, QP.TEMPLATE_PLAN_ID
, QP.JRAD_DOC_VER
, QP.ESIG_MODE
FROM FND_COMMON_LOOKUPS FL
, MFG_LOOKUPS ML3
, QA_PLANS QP
WHERE QP.PLAN_TYPE_CODE = FL.LOOKUP_CODE
AND FL.LOOKUP_TYPE = 'COLLECTION_PLAN_TYPE'
AND QP.SPEC_ASSIGNMENT_TYPE = ML3.LOOKUP_CODE
AND ML3.LOOKUP_TYPE = 'QA_PLAN_SPEC_TYPE'
AND FL.APPLICATION_ID = 250

Columns