Product: | QA - Quality |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.QAFV_COLLECTION_ELEMENTS |
SELECT COLLECTION_ELEMENT.CHAR_ID COLLECTION_ELEMENT_ID
, COLLECTION_ELEMENT.NAME COLLECTION_ELEMENT_NAME
, COLLECTION_ELEMENT.DATA_ENTRY_HINT
, MF1.MEANING DATA_TYPE
, DEFAULT_VALUE
, FN.MEANING ELEMENT_TYPE
, COLLECTION_ELEMENT.LOWER_REASONABLE_LIMIT
, COLLECTION_ELEMENT.LOWER_SPEC_LIMIT LOWER_SPECIFICATION_LIMIT
, COLLECTION_ELEMENT.LOWER_USER_DEFINED_LIMIT
, COLLECTION_ELEMENT.UPPER_REASONABLE_LIMIT
, COLLECTION_ELEMENT.UPPER_SPEC_LIMIT UPPER_SPECIFICATION_LIMIT
, COLLECTION_ELEMENT.UPPER_USER_DEFINED_LIMIT
, COLLECTION_ELEMENT.TARGET_VALUE
, COLLECTION_ELEMENT.PROMPT RESULTS_COLUMN_PROMPT
, MF2.MEANING ENABLED_FLAG
, MF3.MEANING MANDATORY_FLAG
, MT.UNIT_OF_MEASURE
, COLLECTION_ELEMENT.LAST_UPDATE_DATE
, COLLECTION_ELEMENT.LAST_UPDATED_BY
, COLLECTION_ELEMENT.CREATION_DATE
, COLLECTION_ELEMENT.CREATED_BY
FROM QA_CHARS COLLECTION_ELEMENT
, MFG_LOOKUPS MF1
, MFG_LOOKUPS MF2
, MFG_LOOKUPS MF3
, MTL_UNITS_OF_MEASURE MT
, FND_COMMON_LOOKUPS FN
WHERE MF1.LOOKUP_TYPE = 'QA_CHAR_DATATYPE'
AND MF1.LOOKUP_CODE = COLLECTION_ELEMENT.DATATYPE
AND MF2.LOOKUP_TYPE = 'SYS_YES_NO'
AND MF2.LOOKUP_CODE = COLLECTION_ELEMENT.ENABLED_FLAG
AND MF3.LOOKUP_TYPE = 'SYS_YES_NO'
AND MF3.LOOKUP_CODE = COLLECTION_ELEMENT.MANDATORY_FLAG
AND FN.LOOKUP_TYPE = 'ELEMENT_TYPE'
AND FN.LOOKUP_CODE = COLLECTION_ELEMENT.CHAR_TYPE_CODE
AND FN.APPLICATION_ID = 250
AND MT.UOM_CODE (+) = COLLECTION_ELEMENT.UOM_CODE WITH READ ONLY