VIEW: APPS.INVBV_ITEM_RELATIONS

Source

View Text - Preformatted

SELECT AL.NAME , PA.ORGANIZATION_CODE , '_KF:INV:MSTK:SY1' , '_KF:INV:MSTK:SY2' , '_LA:RE.RELATIONSHIP_TYPE_ID:MFG_LOOKUPS:MTL_RELATIONSHIP_TYPES:MEANING' , '_LA:RE.RECIPROCAL_FLAG:FND_LOOKUPS:YES_NO:MEANING' , RE.ORGANIZATION_ID , RE.INVENTORY_ITEM_ID , RE.RELATED_ITEM_ID , RE.LAST_UPDATE_DATE , RE.LAST_UPDATED_BY , RE.CREATION_DATE , RE.CREATED_BY FROM MTL_SYSTEM_ITEMS SY2, MTL_SYSTEM_ITEMS SY1, MTL_PARAMETERS PA, HR_ALL_ORGANIZATION_UNITS AL, MTL_RELATED_ITEMS RE WHERE RE.ORGANIZATION_ID = AL.ORGANIZATION_ID AND RE.ORGANIZATION_ID = PA.ORGANIZATION_ID AND RE.INVENTORY_ITEM_ID = SY1.INVENTORY_ITEM_ID AND RE.ORGANIZATION_ID = SY1.ORGANIZATION_ID AND RE.RELATED_ITEM_ID = SY2.INVENTORY_ITEM_ID AND RE.ORGANIZATION_ID = SY2.ORGANIZATION_ID AND '_SEC:re.organization_id' is not null with read only

View Text - HTML Formatted

SELECT AL.NAME
, PA.ORGANIZATION_CODE
, '_KF:INV:MSTK:SY1'
, '_KF:INV:MSTK:SY2'
, '_LA:RE.RELATIONSHIP_TYPE_ID:MFG_LOOKUPS:MTL_RELATIONSHIP_TYPES:MEANING'
, '_LA:RE.RECIPROCAL_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, RE.ORGANIZATION_ID
, RE.INVENTORY_ITEM_ID
, RE.RELATED_ITEM_ID
, RE.LAST_UPDATE_DATE
, RE.LAST_UPDATED_BY
, RE.CREATION_DATE
, RE.CREATED_BY
FROM MTL_SYSTEM_ITEMS SY2
, MTL_SYSTEM_ITEMS SY1
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_RELATED_ITEMS RE
WHERE RE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND RE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND RE.INVENTORY_ITEM_ID = SY1.INVENTORY_ITEM_ID
AND RE.ORGANIZATION_ID = SY1.ORGANIZATION_ID
AND RE.RELATED_ITEM_ID = SY2.INVENTORY_ITEM_ID
AND RE.ORGANIZATION_ID = SY2.ORGANIZATION_ID
AND '_SEC:RE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY