View: QAFV_COLLECTION_PLAN_ELEMENTS

Product:	QA - Quality
Description:	- Retrofitted
Implementation/DBA Data:	APPS.QAFV_COLLECTION_PLAN_ELEMENTS

View Text

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

Columns