VIEW: APPS.QA_SPECS_V

Source

View Text - Preformatted

SELECT QS.ROWID ROW_ID , QS.SPEC_ID , QS.LAST_UPDATE_DATE , QS.LAST_UPDATED_BY , QS.CREATION_DATE , QS.CREATED_BY , QS.LAST_UPDATE_LOGIN , QS.SPEC_NAME , QS.ORGANIZATION_ID , QS.EFFECTIVE_FROM , QS.EFFECTIVE_TO , QS.COMMON_SPEC_ID , decode(QS.COMMON_SPEC_ID, QS.SPEC_ID, NULL, QS2.SPEC_NAME) COMMON_SPEC_NAME , QS.ASSIGNMENT_TYPE , ML2.MEANING ASSIGNMENT_TYPE_MEANING , decode(QS.CATEGORY_SET_ID, -1, NULL, QS.CATEGORY_SET_ID) CATEGORY_SET_ID , decode(QS.CATEGORY_ID, -1, NULL, QS.CATEGORY_ID) CATEGORY_ID , decode(QS.ITEM_ID, -1, NULL, QS.ITEM_ID) ITEM_ID , decode(QS.ITEM_REVISION, 'NONE', NULL, QS.ITEM_REVISION) ITEM_REVISION , ITL.DESCRIPTION ITEM_DESCRIPTION , decode(QS.VENDOR_ID, -1, NULL, QS.VENDOR_ID) VENDOR_ID , decode(QS.CUSTOMER_ID, -1, NULL, QS.CUSTOMER_ID) CUSTOMER_ID , decode( QS.CHAR_ID, -1, NULL, QS.CHAR_ID ) CHAR_ID , QC.NAME SPEC_ELEMENT , QC.VALUES_EXIST_FLAG , QC.DATATYPE , decode (QC.SQL_VALIDATION_STRING, NULL, 'N', 'Y' ) SQL_STRING_FLAG , QC.DECIMAL_PRECISION , decode (QS.CHAR_ID, -1, NULL, QS.SPEC_ELEMENT_VALUE ) SPEC_ELEMENT_VALUE , CSETTL.CATEGORY_SET_NAME , CSET.STRUCTURE_ID , CSET.VALIDATE_FLAG , V.SEGMENT1 VENDOR_NUMBER , hp1.party_name VENDOR_NAME , hca.account_number CUSTOMER_NUMBER , hp2.party_name CUSTOMER_NAME , NVL(I.REVISION_QTY_CONTROL_CODE,1) REV_CONTROL_FLAG , CSET.VALIDATE_FLAG CAT_SET_VALIDATE_FLAG , QS.HIDE_PLAN_CHARS_FLAG , ML3.MEANING HIDE_PLAN_CHARS_MEANING , QS.ATTRIBUTE_CATEGORY , QS.ATTRIBUTE1 , QS.ATTRIBUTE2 , QS.ATTRIBUTE3 , QS.ATTRIBUTE4 , QS.ATTRIBUTE5 , QS.ATTRIBUTE6 , QS.ATTRIBUTE7 , QS.ATTRIBUTE8 , QS.ATTRIBUTE9 , QS.ATTRIBUTE10 , QS.ATTRIBUTE11 , QS.ATTRIBUTE12 , QS.ATTRIBUTE13 , QS.ATTRIBUTE14 , QS.ATTRIBUTE15 , CSETTL.DESCRIPTION CATEGORY_SET_DESCRIPTION , QS.SPEC_STATUS , ML4.MEANING FROM MFG_LOOKUPS ML2, MFG_LOOKUPS ML3, MFG_LOOKUPS ML4, MTL_CATEGORY_SETS_B CSET, MTL_CATEGORY_SETS_TL CSETTL, ap_suppliers V, hz_parties hp1, hz_cust_accounts hca, hz_parties hp2, MTL_SYSTEM_ITEMS_B I, MTL_SYSTEM_ITEMS_TL ITL, QA_SPECS QS2, QA_SPECS QS, QA_CHARS QC WHERE QS.ASSIGNMENT_TYPE = ML2.LOOKUP_CODE AND ML2.LOOKUP_TYPE = 'QA_SPEC_TYPE' AND QS.HIDE_PLAN_CHARS_FLAG = ML3.LOOKUP_CODE AND ML3.LOOKUP_TYPE = 'SYS_YES_NO' AND QS.CATEGORY_SET_ID = CSET.CATEGORY_SET_ID (+) AND QS.CATEGORY_SET_ID = CSETTL.CATEGORY_SET_ID (+) AND CSETTL.LANGUAGE (+) = USERENV('LANG') AND QS.VENDOR_ID = V.VENDOR_ID (+) AND v.party_id = hp1.party_id (+) AND QS.CUSTOMER_ID = hca.cust_account_id (+) AND hca.party_id = hp2.party_id (+) AND QS.ITEM_ID = I.INVENTORY_ITEM_ID (+) AND QS.ORGANIZATION_ID = I.ORGANIZATION_ID (+) AND QS.ITEM_ID = ITL.INVENTORY_ITEM_ID (+) AND QS.ORGANIZATION_ID = ITL.ORGANIZATION_ID (+) AND ITL.LANGUAGE (+) = USERENV('LANG') AND QS.COMMON_SPEC_ID = QS2.SPEC_ID AND QS.CHAR_ID = QC.CHAR_ID (+) AND QS.SPEC_STATUS = ML4.LOOKUP_CODE (+) AND ML4.LOOKUP_TYPE (+) = 'QA_ERES_SPEC_STATUS'

View Text - HTML Formatted

SELECT QS.ROWID ROW_ID
, QS.SPEC_ID
, QS.LAST_UPDATE_DATE
, QS.LAST_UPDATED_BY
, QS.CREATION_DATE
, QS.CREATED_BY
, QS.LAST_UPDATE_LOGIN
, QS.SPEC_NAME
, QS.ORGANIZATION_ID
, QS.EFFECTIVE_FROM
, QS.EFFECTIVE_TO
, QS.COMMON_SPEC_ID
, DECODE(QS.COMMON_SPEC_ID
, QS.SPEC_ID
, NULL
, QS2.SPEC_NAME) COMMON_SPEC_NAME
, QS.ASSIGNMENT_TYPE
, ML2.MEANING ASSIGNMENT_TYPE_MEANING
, DECODE(QS.CATEGORY_SET_ID
, -1
, NULL
, QS.CATEGORY_SET_ID) CATEGORY_SET_ID
, DECODE(QS.CATEGORY_ID
, -1
, NULL
, QS.CATEGORY_ID) CATEGORY_ID
, DECODE(QS.ITEM_ID
, -1
, NULL
, QS.ITEM_ID) ITEM_ID
, DECODE(QS.ITEM_REVISION
, 'NONE'
, NULL
, QS.ITEM_REVISION) ITEM_REVISION
, ITL.DESCRIPTION ITEM_DESCRIPTION
, DECODE(QS.VENDOR_ID
, -1
, NULL
, QS.VENDOR_ID) VENDOR_ID
, DECODE(QS.CUSTOMER_ID
, -1
, NULL
, QS.CUSTOMER_ID) CUSTOMER_ID
, DECODE( QS.CHAR_ID
, -1
, NULL
, QS.CHAR_ID ) CHAR_ID
, QC.NAME SPEC_ELEMENT
, QC.VALUES_EXIST_FLAG
, QC.DATATYPE
, DECODE (QC.SQL_VALIDATION_STRING
, NULL
, 'N'
, 'Y' ) SQL_STRING_FLAG
, QC.DECIMAL_PRECISION
, DECODE (QS.CHAR_ID
, -1
, NULL
, QS.SPEC_ELEMENT_VALUE ) SPEC_ELEMENT_VALUE
, CSETTL.CATEGORY_SET_NAME
, CSET.STRUCTURE_ID
, CSET.VALIDATE_FLAG
, V.SEGMENT1 VENDOR_NUMBER
, HP1.PARTY_NAME VENDOR_NAME
, HCA.ACCOUNT_NUMBER CUSTOMER_NUMBER
, HP2.PARTY_NAME CUSTOMER_NAME
, NVL(I.REVISION_QTY_CONTROL_CODE
, 1) REV_CONTROL_FLAG
, CSET.VALIDATE_FLAG CAT_SET_VALIDATE_FLAG
, QS.HIDE_PLAN_CHARS_FLAG
, ML3.MEANING HIDE_PLAN_CHARS_MEANING
, QS.ATTRIBUTE_CATEGORY
, QS.ATTRIBUTE1
, QS.ATTRIBUTE2
, QS.ATTRIBUTE3
, QS.ATTRIBUTE4
, QS.ATTRIBUTE5
, QS.ATTRIBUTE6
, QS.ATTRIBUTE7
, QS.ATTRIBUTE8
, QS.ATTRIBUTE9
, QS.ATTRIBUTE10
, QS.ATTRIBUTE11
, QS.ATTRIBUTE12
, QS.ATTRIBUTE13
, QS.ATTRIBUTE14
, QS.ATTRIBUTE15
, CSETTL.DESCRIPTION CATEGORY_SET_DESCRIPTION
, QS.SPEC_STATUS
, ML4.MEANING
FROM MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
, MFG_LOOKUPS ML4
, MTL_CATEGORY_SETS_B CSET
, MTL_CATEGORY_SETS_TL CSETTL
, AP_SUPPLIERS V
, HZ_PARTIES HP1
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HP2
, MTL_SYSTEM_ITEMS_B I
, MTL_SYSTEM_ITEMS_TL ITL
, QA_SPECS QS2
, QA_SPECS QS
, QA_CHARS QC
WHERE QS.ASSIGNMENT_TYPE = ML2.LOOKUP_CODE
AND ML2.LOOKUP_TYPE = 'QA_SPEC_TYPE'
AND QS.HIDE_PLAN_CHARS_FLAG = ML3.LOOKUP_CODE
AND ML3.LOOKUP_TYPE = 'SYS_YES_NO'
AND QS.CATEGORY_SET_ID = CSET.CATEGORY_SET_ID (+)
AND QS.CATEGORY_SET_ID = CSETTL.CATEGORY_SET_ID (+)
AND CSETTL.LANGUAGE (+) = USERENV('LANG')
AND QS.VENDOR_ID = V.VENDOR_ID (+)
AND V.PARTY_ID = HP1.PARTY_ID (+)
AND QS.CUSTOMER_ID = HCA.CUST_ACCOUNT_ID (+)
AND HCA.PARTY_ID = HP2.PARTY_ID (+)
AND QS.ITEM_ID = I.INVENTORY_ITEM_ID (+)
AND QS.ORGANIZATION_ID = I.ORGANIZATION_ID (+)
AND QS.ITEM_ID = ITL.INVENTORY_ITEM_ID (+)
AND QS.ORGANIZATION_ID = ITL.ORGANIZATION_ID (+)
AND ITL.LANGUAGE (+) = USERENV('LANG')
AND QS.COMMON_SPEC_ID = QS2.SPEC_ID
AND QS.CHAR_ID = QC.CHAR_ID (+)
AND QS.SPEC_STATUS = ML4.LOOKUP_CODE (+)
AND ML4.LOOKUP_TYPE (+) = 'QA_ERES_SPEC_STATUS'