VIEW: APPS.QA_ERES_PLANS_V

Source

View Text - Preformatted

SELECT 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.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, QL1.MEANING, MP.ORGANIZATION_CODE, HRORG.NAME FROM FND_COMMON_LOOKUPS FL, MFG_LOOKUPS ML3, QA_PLANS QP, MTL_PARAMETERS MP, HR_ALL_ORGANIZATION_UNITS_TL HRORG, QA_LOOKUPS QL1 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 QP.ORGANIZATION_ID = MP.ORGANIZATION_ID (+) AND HRORG.LANGUAGE (+) = USERENV('LANG') AND QP.ORGANIZATION_ID = HRORG.ORGANIZATION_ID (+) AND QP.ESIG_MODE = QL1.LOOKUP_CODE (+) AND QL1.LOOKUP_TYPE (+) = 'QA_ERES_RESULT_TYPE'

View Text - HTML Formatted

SELECT 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.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
, QL1.MEANING
, MP.ORGANIZATION_CODE
, HRORG.NAME
FROM FND_COMMON_LOOKUPS FL
, MFG_LOOKUPS ML3
, QA_PLANS QP
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS_TL HRORG
, QA_LOOKUPS QL1
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 QP.ORGANIZATION_ID = MP.ORGANIZATION_ID (+)
AND HRORG.LANGUAGE (+) = USERENV('LANG')
AND QP.ORGANIZATION_ID = HRORG.ORGANIZATION_ID (+)
AND QP.ESIG_MODE = QL1.LOOKUP_CODE (+)
AND QL1.LOOKUP_TYPE (+) = 'QA_ERES_RESULT_TYPE'