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.

VIEW: APPS.QAFV_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, 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

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
, 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