VIEW: APPS.QAFV_COLLECTION_ELEMENTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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