VIEW: APPS.GMD_SPEC_SUMMARY

Source

View Text - Preformatted

SELECT A.ROW_ID, A.SPEC_ID, A.SPEC_NAME, A.SPEC_VERS, A.SPEC_DESC, A.INVENTORY_ITEM_ID, D.CONCATENATED_SEGMENTS ITEM_NUMBER, A.REVISION, A.GRADE_CODE, A.SPEC_STATUS, A.OWNER_ORGANIZATION_ID, C.ORGANIZATION_CODE OWNER_ORGANIZATION_CODE, A.OWNER_ID, A.SAMPLE_INV_TRANS_IND, A.DELETE_MARK, A.TEXT_CODE, A.ATTRIBUTE_CATEGORY, A.ATTRIBUTE1, A.ATTRIBUTE2, A.ATTRIBUTE3, A.ATTRIBUTE4, A.ATTRIBUTE5, A.ATTRIBUTE6, A.ATTRIBUTE7, A.ATTRIBUTE8, A.ATTRIBUTE9, A.ATTRIBUTE10, A.ATTRIBUTE11, A.ATTRIBUTE12, A.ATTRIBUTE13, A.ATTRIBUTE14, A.ATTRIBUTE15, A.ATTRIBUTE16, A.ATTRIBUTE17, A.ATTRIBUTE18, A.ATTRIBUTE19, A.ATTRIBUTE20, A.ATTRIBUTE21, A.ATTRIBUTE22, A.ATTRIBUTE23, A.ATTRIBUTE24, A.ATTRIBUTE25, A.ATTRIBUTE26, A.ATTRIBUTE27, A.ATTRIBUTE28, A.ATTRIBUTE29, A.ATTRIBUTE30, A.CREATION_DATE, A.CREATED_BY, A.LAST_UPDATED_BY, A.LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN, A.SPEC_TYPE, A.OVERLAY_IND, A.BASE_SPEC_ID, B.MEANING SPEC_STATUS_DESC FROM GMD_SPECIFICATIONS_VL A, GMD_QC_STATUS_VL B, MTL_PARAMETERS C, MTL_SYSTEM_ITEMS_B_KFV D WHERE A.SPEC_STATUS = B.STATUS_CODE AND B.ENTITY_TYPE = 'S' AND A.OWNER_ORGANIZATION_ID = C.ORGANIZATION_ID AND A.INVENTORY_ITEM_ID = D.INVENTORY_ITEM_ID(+) AND A.OWNER_ORGANIZATION_ID = D.ORGANIZATION_ID

View Text - HTML Formatted

SELECT A.ROW_ID
, A.SPEC_ID
, A.SPEC_NAME
, A.SPEC_VERS
, A.SPEC_DESC
, A.INVENTORY_ITEM_ID
, D.CONCATENATED_SEGMENTS ITEM_NUMBER
, A.REVISION
, A.GRADE_CODE
, A.SPEC_STATUS
, A.OWNER_ORGANIZATION_ID
, C.ORGANIZATION_CODE OWNER_ORGANIZATION_CODE
, A.OWNER_ID
, A.SAMPLE_INV_TRANS_IND
, A.DELETE_MARK
, A.TEXT_CODE
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.ATTRIBUTE16
, A.ATTRIBUTE17
, A.ATTRIBUTE18
, A.ATTRIBUTE19
, A.ATTRIBUTE20
, A.ATTRIBUTE21
, A.ATTRIBUTE22
, A.ATTRIBUTE23
, A.ATTRIBUTE24
, A.ATTRIBUTE25
, A.ATTRIBUTE26
, A.ATTRIBUTE27
, A.ATTRIBUTE28
, A.ATTRIBUTE29
, A.ATTRIBUTE30
, A.CREATION_DATE
, A.CREATED_BY
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
, A.SPEC_TYPE
, A.OVERLAY_IND
, A.BASE_SPEC_ID
, B.MEANING SPEC_STATUS_DESC
FROM GMD_SPECIFICATIONS_VL A
, GMD_QC_STATUS_VL B
, MTL_PARAMETERS C
, MTL_SYSTEM_ITEMS_B_KFV D
WHERE A.SPEC_STATUS = B.STATUS_CODE
AND B.ENTITY_TYPE = 'S'
AND A.OWNER_ORGANIZATION_ID = C.ORGANIZATION_ID
AND A.INVENTORY_ITEM_ID = D.INVENTORY_ITEM_ID(+)
AND A.OWNER_ORGANIZATION_ID = D.ORGANIZATION_ID