VIEW: APPS.GR_ITEM_GENERAL_V

Source

View Text - Preformatted

SELECT A.ORGANIZATION_ID ORGANIZATION_ID , A.INVENTORY_ITEM_ID INVENTORY_ITEM_ID , A.CONCATENATED_SEGMENTS ITEM_CODE , NULL ITEM_GROUP_CODE , A.CAS_NUMBER PRIMARY_CAS_NUMBER , B.INGREDIENT_FLAG INGREDIENT_FLAG , B.EXPLODE_INGREDIENT_FLAG EXPLODE_INGREDIENT_FLAG , 'P' FORMULA_SOURCE_INDICATOR , A.CREATED_BY USER_ID , NULL INTERNAL_REFERENCE_NUMBER , NULL PRODUCT_LABEL_CODE , NULL VERSION_CODE , NULL LAST_VERSION_CODE , NULL PRODUCT_CLASS , B.ACTUAL_HAZARD ACTUAL_HAZARD , NULL PRINT_INGREDIENT_PHRASES_FLAG , NULL ATTRIBUTE_CATEGORY , NULL ATTRIBUTE1 , NULL ATTRIBUTE2 , NULL ATTRIBUTE3 , NULL ATTRIBUTE4 , NULL ATTRIBUTE5 , NULL ATTRIBUTE6 , NULL ATTRIBUTE7 , NULL ATTRIBUTE8 , NULL ATTRIBUTE9 , NULL ATTRIBUTE10 , NULL ATTRIBUTE11 , NULL ATTRIBUTE12 , NULL ATTRIBUTE13 , NULL ATTRIBUTE14 , NULL ATTRIBUTE15 , NULL ATTRIBUTE16 , NULL ATTRIBUTE17 , NULL ATTRIBUTE18 , NULL ATTRIBUTE19 , NULL ATTRIBUTE20 , NULL ATTRIBUTE21 , NULL ATTRIBUTE22 , NULL ATTRIBUTE23 , NULL ATTRIBUTE24 , NULL ATTRIBUTE25 , NULL ATTRIBUTE26 , NULL ATTRIBUTE27 , NULL ATTRIBUTE28 , NULL ATTRIBUTE29 , NULL ATTRIBUTE30 , A.CREATED_BY CREATED_BY , A.CREATION_DATE CREATION_DATE , A.LAST_UPDATED_BY LAST_UPDATED_BY , A.LAST_UPDATE_DATE LAST_UPDATE_DATE , A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM MTL_SYSTEM_ITEMS_KFV A , GR_ITEM_EXPLOSION_PROPERTIES B WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID(+) AND A.ORGANIZATION_ID = B.ORGANIZATION_ID (+)

View Text - HTML Formatted

SELECT A.ORGANIZATION_ID ORGANIZATION_ID
, A.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, A.CONCATENATED_SEGMENTS ITEM_CODE
, NULL ITEM_GROUP_CODE
, A.CAS_NUMBER PRIMARY_CAS_NUMBER
, B.INGREDIENT_FLAG INGREDIENT_FLAG
, B.EXPLODE_INGREDIENT_FLAG EXPLODE_INGREDIENT_FLAG
, 'P' FORMULA_SOURCE_INDICATOR
, A.CREATED_BY USER_ID
, NULL INTERNAL_REFERENCE_NUMBER
, NULL PRODUCT_LABEL_CODE
, NULL VERSION_CODE
, NULL LAST_VERSION_CODE
, NULL PRODUCT_CLASS
, B.ACTUAL_HAZARD ACTUAL_HAZARD
, NULL PRINT_INGREDIENT_PHRASES_FLAG
, NULL ATTRIBUTE_CATEGORY
, NULL ATTRIBUTE1
, NULL ATTRIBUTE2
, NULL ATTRIBUTE3
, NULL ATTRIBUTE4
, NULL ATTRIBUTE5
, NULL ATTRIBUTE6
, NULL ATTRIBUTE7
, NULL ATTRIBUTE8
, NULL ATTRIBUTE9
, NULL ATTRIBUTE10
, NULL ATTRIBUTE11
, NULL ATTRIBUTE12
, NULL ATTRIBUTE13
, NULL ATTRIBUTE14
, NULL ATTRIBUTE15
, NULL ATTRIBUTE16
, NULL ATTRIBUTE17
, NULL ATTRIBUTE18
, NULL ATTRIBUTE19
, NULL ATTRIBUTE20
, NULL ATTRIBUTE21
, NULL ATTRIBUTE22
, NULL ATTRIBUTE23
, NULL ATTRIBUTE24
, NULL ATTRIBUTE25
, NULL ATTRIBUTE26
, NULL ATTRIBUTE27
, NULL ATTRIBUTE28
, NULL ATTRIBUTE29
, NULL ATTRIBUTE30
, A.CREATED_BY CREATED_BY
, A.CREATION_DATE CREATION_DATE
, A.LAST_UPDATED_BY LAST_UPDATED_BY
, A.LAST_UPDATE_DATE LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
FROM MTL_SYSTEM_ITEMS_KFV A
, GR_ITEM_EXPLOSION_PROPERTIES B
WHERE A.INVENTORY_ITEM_ID = B.INVENTORY_ITEM_ID(+)
AND A.ORGANIZATION_ID = B.ORGANIZATION_ID (+)