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.QAFV_COLLECTION_PLAN_ELEMENTS

Source

View Text - Preformatted


SELECT COLLECTION_PLAN_ELEMENT.PLAN_ID COLLECTION_PLAN_ID , COLLECTION_PLAN.NAME COLLECTION_PLAN_NAME , COLLECTION_PLAN_ELEMENT.CHAR_ID COLLECTION_ELEMENT_ID , COLLECTION_ELEMENT.NAME COLLECTION_ELEMENT_NAME , COLLECTION_PLAN_ELEMENT.DEFAULT_VALUE DEFAULT_VALUE , COLLECTION_PLAN_ELEMENT.PROMPT RESULTS_COLUMN_PROMPT , MF1.MEANING ENABLED_FLAG , MF2.MEANING MANDATORY_FLAG , COLLECTION_PLAN_ELEMENT.LAST_UPDATE_DATE , COLLECTION_PLAN_ELEMENT.LAST_UPDATED_BY , COLLECTION_PLAN_ELEMENT.CREATION_DATE , COLLECTION_PLAN_ELEMENT.CREATED_BY FROM QA_PLAN_CHARS COLLECTION_PLAN_ELEMENT, QA_PLANS COLLECTION_PLAN, QA_CHARS COLLECTION_ELEMENT, MFG_LOOKUPS MF1, MFG_LOOKUPS MF2 WHERE COLLECTION_PLAN_ELEMENT.PLAN_ID = COLLECTION_PLAN.PLAN_ID AND COLLECTION_PLAN_ELEMENT.CHAR_ID = COLLECTION_ELEMENT.CHAR_ID AND MF1.LOOKUP_TYPE = 'SYS_YES_NO' AND MF1.LOOKUP_CODE = COLLECTION_PLAN_ELEMENT.ENABLED_FLAG AND MF2.LOOKUP_TYPE = 'SYS_YES_NO' AND MF2.LOOKUP_CODE = COLLECTION_PLAN_ELEMENT.MANDATORY_FLAG WITH READ ONLY

View Text - HTML Formatted

SELECT COLLECTION_PLAN_ELEMENT.PLAN_ID COLLECTION_PLAN_ID
, COLLECTION_PLAN.NAME COLLECTION_PLAN_NAME
, COLLECTION_PLAN_ELEMENT.CHAR_ID COLLECTION_ELEMENT_ID
, COLLECTION_ELEMENT.NAME COLLECTION_ELEMENT_NAME
, COLLECTION_PLAN_ELEMENT.DEFAULT_VALUE DEFAULT_VALUE
, COLLECTION_PLAN_ELEMENT.PROMPT RESULTS_COLUMN_PROMPT
, MF1.MEANING ENABLED_FLAG
, MF2.MEANING MANDATORY_FLAG
, COLLECTION_PLAN_ELEMENT.LAST_UPDATE_DATE
, COLLECTION_PLAN_ELEMENT.LAST_UPDATED_BY
, COLLECTION_PLAN_ELEMENT.CREATION_DATE
, COLLECTION_PLAN_ELEMENT.CREATED_BY
FROM QA_PLAN_CHARS COLLECTION_PLAN_ELEMENT
, QA_PLANS COLLECTION_PLAN
, QA_CHARS COLLECTION_ELEMENT
, MFG_LOOKUPS MF1
, MFG_LOOKUPS MF2
WHERE COLLECTION_PLAN_ELEMENT.PLAN_ID = COLLECTION_PLAN.PLAN_ID
AND COLLECTION_PLAN_ELEMENT.CHAR_ID = COLLECTION_ELEMENT.CHAR_ID
AND MF1.LOOKUP_TYPE = 'SYS_YES_NO'
AND MF1.LOOKUP_CODE = COLLECTION_PLAN_ELEMENT.ENABLED_FLAG
AND MF2.LOOKUP_TYPE = 'SYS_YES_NO'
AND MF2.LOOKUP_CODE = COLLECTION_PLAN_ELEMENT.MANDATORY_FLAG WITH READ ONLY