eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.QA_PLANS_VAL_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.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.ESIG_MODE FROM FND_COMMON_LOOKUPS FL,MFG_LOOKUPS ML3,QA_PLANS QP WHERE QP.PLAN_TYPE_CODE = FL.LOOKUP_CODE AND FL.APPLICATION_ID = 250 AND FL.LOOKUP_TYPE = 'COLLECTION_PLAN_TYPE' AND QP.SPEC_ASSIGNMENT_TYPE = ML3.LOOKUP_CODE AND ML3.LOOKUP_TYPE = 'QA_PLAN_SPEC_TYPE' AND ((QP.EFFECTIVE_TO IS NULL AND TRUNC(SYSDATE) >= QP.EFFECTIVE_FROM) OR (QP.EFFECTIVE_FROM IS NULL AND TRUNC(SYSDATE) <= QP.EFFECTIVE_TO) OR (QP.EFFECTIVE_FROM IS NOT NULL AND QP.EFFECTIVE_TO IS NOT NULL AND TRUNC(SYSDATE) BETWEEN QP.EFFECTIVE_FROM AND QP.EFFECTIVE_TO) OR (QP.EFFECTIVE_FROM IS NULL AND QP.EFFECTIVE_TO IS NULL ))

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.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.ESIG_MODE
FROM FND_COMMON_LOOKUPS FL
, MFG_LOOKUPS ML3
, QA_PLANS QP
WHERE QP.PLAN_TYPE_CODE = FL.LOOKUP_CODE
AND FL.APPLICATION_ID = 250
AND FL.LOOKUP_TYPE = 'COLLECTION_PLAN_TYPE'
AND QP.SPEC_ASSIGNMENT_TYPE = ML3.LOOKUP_CODE
AND ML3.LOOKUP_TYPE = 'QA_PLAN_SPEC_TYPE'
AND ((QP.EFFECTIVE_TO IS NULL
AND TRUNC(SYSDATE) >= QP.EFFECTIVE_FROM) OR (QP.EFFECTIVE_FROM IS NULL
AND TRUNC(SYSDATE) <= QP.EFFECTIVE_TO) OR (QP.EFFECTIVE_FROM IS NOT NULL
AND QP.EFFECTIVE_TO IS NOT NULL
AND TRUNC(SYSDATE) BETWEEN QP.EFFECTIVE_FROM
AND QP.EFFECTIVE_TO) OR (QP.EFFECTIVE_FROM IS NULL
AND QP.EFFECTIVE_TO IS NULL ))