View: GR_ITEM_GENERAL_V

Product:	GR - Process Manufacturing Regulatory Management
Description:	View of Regulatory Item details, includes the items details for Regulatory Items with regard to the Convergence model
Implementation/DBA Data:	APPS.GR_ITEM_GENERAL_V

View Text

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 (+)

Columns