Product: | QA - Quality |
---|---|
Description: | All plans for electronic records |
Implementation/DBA Data: | APPS.QA_ERES_PLANS_V |
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'