VIEW: APPS.QA_PLANS_V

Source

View Text - Preformatted

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 , NVL(QP.MULTIROW_FLAG,2) MULTIROW_FLAG , ML4.MEANING MULTIROW_FLAG_MEANING FROM FND_COMMON_LOOKUPS FL,MFG_LOOKUPS ML3,QA_PLANS QP,MFG_LOOKUPS ML4 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 AND ML4.LOOKUP_TYPE = 'SYS_YES_NO' AND NVL(QP.MULTIROW_FLAG, 2) = ML4.LOOKUP_CODE

View Text - HTML Formatted

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
, NVL(QP.MULTIROW_FLAG
, 2) MULTIROW_FLAG
, ML4.MEANING MULTIROW_FLAG_MEANING
FROM FND_COMMON_LOOKUPS FL
, MFG_LOOKUPS ML3
, QA_PLANS QP
, MFG_LOOKUPS ML4
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
AND ML4.LOOKUP_TYPE = 'SYS_YES_NO'
AND NVL(QP.MULTIROW_FLAG
, 2) = ML4.LOOKUP_CODE