eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: QAFV_QUALITY_SPECIFICATIONS

Product:	QA - Quality
Description:	- Retrofitted
Implementation/DBA Data:	APPS.QAFV_QUALITY_SPECIFICATIONS

View Text

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
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, QUALITY_SPECIFICATION.CATEGORY_ID
, '_KF:INV:MCAT:CA2'
, QUALITY_SPECIFICATION.CATEGORY_SET_ID
, CA1.CATEGORY_SET_NAME
, QUALITY_SPECIFICATION.ITEM_ID
, '_KF:INV:MSTK:SY'
, QUALITY_SPECIFICATION.ITEM_REVISION
, QUALITY_SPECIFICATION.VENDOR_ID
, PV.VENDOR_NAME
, QUALITY_SPECIFICATION.CUSTOMER_ID
, RC.CUSTOMER_NAME
, QUALITY_SPECIFICATION.CHAR_ID SUBTYPE_ELEMENT_ID
, COLLECTION_ELEMENT.NAME SUBTYPE_ELEMENT_NAME
, 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
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, QA_CHARS COLLECTION_ELEMENT
, QA_CUSTOMERS_LOV_V RC
, PO_VENDORS PV
, MTL_SYSTEM_ITEMS SY
, MTL_CATEGORY_SETS CA1
, MTL_CATEGORIES CA2
WHERE MF.LOOKUP_TYPE = 'QA_SPEC_TYPE'
AND MF.LOOKUP_CODE = QUALITY_SPECIFICATION.ASSIGNMENT_TYPE
AND AL.ORGANIZATION_ID = QUALITY_SPECIFICATION.ORGANIZATION_ID
AND PA.ORGANIZATION_ID = QUALITY_SPECIFICATION.ORGANIZATION_ID
AND COLLECTION_ELEMENT.CHAR_ID (+) = QUALITY_SPECIFICATION.CHAR_ID
AND RC.CUSTOMER_ID (+) = QUALITY_SPECIFICATION.CUSTOMER_ID
AND PV.VENDOR_ID (+) = QUALITY_SPECIFICATION.VENDOR_ID
AND SY.INVENTORY_ITEM_ID (+) = QUALITY_SPECIFICATION.ITEM_ID
AND SY.ORGANIZATION_ID (+) = QUALITY_SPECIFICATION.ORGANIZATION_ID
AND CA1.CATEGORY_SET_ID (+) = QUALITY_SPECIFICATION.CATEGORY_SET_ID
AND CA2.CATEGORY_ID (+) = QUALITY_SPECIFICATION.CATEGORY_ID WITH READ ONLY

Columns

Name
SPECIFICATION_ID
SPECIFICATION_NAME
START_EFFECTIVE_DATE
END_EFFECTIVE_DATE
SUBTYPE_ELEMENT_VALUE
ASSIGNMENT_TYPE
ORGANIZATION_ID
ORGANIZATION_CODE
ORGANIZATION_NAME
CATEGORY_ID
"_KF:CATEGORY_NAME"
CATEGORY_SET_ID
CATEGORY_SET_NAME
ITEM_ID
"_KF:ITEM_NAME"
ITEM_REVISION
VENDOR_ID
VENDOR_NAME
CUSTOMER_ID
CUSTOMER_NAME
SUBTYPE_ELEMENT_ID
SUBTYPE_ELEMENT_NAME
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY