VIEW: APPS.QAFV_QUALSPCELM

Source

View Text - Preformatted

SELECT QUALITY_SPECIFICATION_ELEMENT.SPEC_ID SPECIFICATION_ID , QUALITY_SPECIFICATION.SPEC_NAME SPECIFICATION_NAME , QUALITY_SPECIFICATION_ELEMENT.CHAR_ID COLLECTION_ELEMENT_ID , COLLECTION_ELEMENT.NAME COLLECTION_ELEMENT_NAME , QUALITY_SPECIFICATION_ELEMENT.LOWER_REASONABLE_LIMIT , QUALITY_SPECIFICATION_ELEMENT.LOWER_SPEC_LIMIT LOWER_SPECIFICATION_LIMIT , QUALITY_SPECIFICATION_ELEMENT.LOWER_USER_DEFINED_LIMIT , QUALITY_SPECIFICATION_ELEMENT.UPPER_REASONABLE_LIMIT , QUALITY_SPECIFICATION_ELEMENT.UPPER_SPEC_LIMIT UPPER_SPECIFICATION_LIMIT , QUALITY_SPECIFICATION_ELEMENT.UPPER_USER_DEFINED_LIMIT , QUALITY_SPECIFICATION_ELEMENT.TARGET_VALUE , MF.MEANING ENABLED_FLAG , QUALITY_SPECIFICATION_ELEMENT.LAST_UPDATE_DATE , QUALITY_SPECIFICATION_ELEMENT.LAST_UPDATED_BY , QUALITY_SPECIFICATION_ELEMENT.CREATION_DATE , QUALITY_SPECIFICATION_ELEMENT.CREATED_BY FROM QA_CHARS COLLECTION_ELEMENT, QA_SPECS QUALITY_SPECIFICATION, QA_SPEC_CHARS QUALITY_SPECIFICATION_ELEMENT, MFG_LOOKUPS MF WHERE QUALITY_SPECIFICATION_ELEMENT.SPEC_ID = QUALITY_SPECIFICATION.SPEC_ID AND QUALITY_SPECIFICATION_ELEMENT.CHAR_ID = COLLECTION_ELEMENT.CHAR_ID AND MF.LOOKUP_TYPE = 'SYS_YES_NO' AND MF.LOOKUP_CODE = QUALITY_SPECIFICATION_ELEMENT.ENABLED_FLAG WITH READ ONLY

View Text - HTML Formatted

SELECT QUALITY_SPECIFICATION_ELEMENT.SPEC_ID SPECIFICATION_ID
, QUALITY_SPECIFICATION.SPEC_NAME SPECIFICATION_NAME
, QUALITY_SPECIFICATION_ELEMENT.CHAR_ID COLLECTION_ELEMENT_ID
, COLLECTION_ELEMENT.NAME COLLECTION_ELEMENT_NAME
, QUALITY_SPECIFICATION_ELEMENT.LOWER_REASONABLE_LIMIT
, QUALITY_SPECIFICATION_ELEMENT.LOWER_SPEC_LIMIT LOWER_SPECIFICATION_LIMIT
, QUALITY_SPECIFICATION_ELEMENT.LOWER_USER_DEFINED_LIMIT
, QUALITY_SPECIFICATION_ELEMENT.UPPER_REASONABLE_LIMIT
, QUALITY_SPECIFICATION_ELEMENT.UPPER_SPEC_LIMIT UPPER_SPECIFICATION_LIMIT
, QUALITY_SPECIFICATION_ELEMENT.UPPER_USER_DEFINED_LIMIT
, QUALITY_SPECIFICATION_ELEMENT.TARGET_VALUE
, MF.MEANING ENABLED_FLAG
, QUALITY_SPECIFICATION_ELEMENT.LAST_UPDATE_DATE
, QUALITY_SPECIFICATION_ELEMENT.LAST_UPDATED_BY
, QUALITY_SPECIFICATION_ELEMENT.CREATION_DATE
, QUALITY_SPECIFICATION_ELEMENT.CREATED_BY
FROM QA_CHARS COLLECTION_ELEMENT
, QA_SPECS QUALITY_SPECIFICATION
, QA_SPEC_CHARS QUALITY_SPECIFICATION_ELEMENT
, MFG_LOOKUPS MF
WHERE QUALITY_SPECIFICATION_ELEMENT.SPEC_ID = QUALITY_SPECIFICATION.SPEC_ID
AND QUALITY_SPECIFICATION_ELEMENT.CHAR_ID = COLLECTION_ELEMENT.CHAR_ID
AND MF.LOOKUP_TYPE = 'SYS_YES_NO'
AND MF.LOOKUP_CODE = QUALITY_SPECIFICATION_ELEMENT.ENABLED_FLAG WITH READ ONLY