VIEW: APPS.QABV_QUALITY_SPECIFICATIONS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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