Product: | QA - Quality |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.QABV_QUALITY_SPECIFICATIONS |
SELECT QUALITY_SPECIFICATION.SPEC_ID SPECIFICATION_ID
, QUALITY_SPECIFICATION.SPEC_NAME SPECIFICATION_NAME
, QUALITY_SPECIFICATION.EFFECTIVE_FROM START_EFFECTIVE_DATE
, QUALITY_SPECIFICATION.EFFECTIVE_TO END_EFFECTIVE_DATE
, QUALITY_SPECIFICATION.SPEC_ELEMENT_VALUE SUBTYPE_ELEMENT_VALUE
, MF.MEANING ASSIGNMENT_TYPE
, QUALITY_SPECIFICATION.ORGANIZATION_ID
, QUALITY_SPECIFICATION.CATEGORY_ID
, QUALITY_SPECIFICATION.CATEGORY_SET_ID
, QUALITY_SPECIFICATION.ITEM_ID
, QUALITY_SPECIFICATION.ITEM_REVISION
, QUALITY_SPECIFICATION.VENDOR_ID
, QUALITY_SPECIFICATION.CUSTOMER_ID
, QUALITY_SPECIFICATION.CHAR_ID SUBTYPE_ELEMENT_ID
, QUALITY_SPECIFICATION.LAST_UPDATE_DATE
, QUALITY_SPECIFICATION.LAST_UPDATED_BY
, QUALITY_SPECIFICATION.CREATION_DATE
, QUALITY_SPECIFICATION.CREATED_BY
FROM QA_SPECS QUALITY_SPECIFICATION
, MFG_LOOKUPS MF
WHERE MF.LOOKUP_TYPE = 'QA_SPEC_TYPE'
AND MF.LOOKUP_CODE = QUALITY_SPECIFICATION.ASSIGNMENT_TYPE WITH READ ONLY