VIEW: APPS.INVBV_MFG_PART_NUMBERS

Source

View Text - Preformatted

SELECT MA.MANUFACTURER_NAME , MF.MFG_PART_NUM , AL.NAME , PA.ORGANIZATION_CODE ,'_KF:INV:MSTK:SY' , MF.MANUFACTURER_ID , MF.INVENTORY_ITEM_ID , MF.ORGANIZATION_ID , MF.LAST_UPDATE_DATE , MF.LAST_UPDATED_BY , MF.CREATION_DATE , MF.CREATED_BY FROM MTL_PARAMETERS PA, HR_ALL_ORGANIZATION_UNITS AL, MTL_SYSTEM_ITEMS SY, MTL_MANUFACTURERS MA, MTL_MFG_PART_NUMBERS MF WHERE MF.MANUFACTURER_ID = MA.MANUFACTURER_ID AND MF.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID AND MF.ORGANIZATION_ID = SY.ORGANIZATION_ID AND MF.ORGANIZATION_ID = AL.ORGANIZATION_ID AND MF.ORGANIZATION_ID = PA.ORGANIZATION_ID AND '_SEC:mf.organization_id' is not null with read only

View Text - HTML Formatted

SELECT MA.MANUFACTURER_NAME
, MF.MFG_PART_NUM
, AL.NAME
, PA.ORGANIZATION_CODE
, '_KF:INV:MSTK:SY'
, MF.MANUFACTURER_ID
, MF.INVENTORY_ITEM_ID
, MF.ORGANIZATION_ID
, MF.LAST_UPDATE_DATE
, MF.LAST_UPDATED_BY
, MF.CREATION_DATE
, MF.CREATED_BY
FROM MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS SY
, MTL_MANUFACTURERS MA
, MTL_MFG_PART_NUMBERS MF
WHERE MF.MANUFACTURER_ID = MA.MANUFACTURER_ID
AND MF.INVENTORY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND MF.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND MF.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND MF.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND '_SEC:MF.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY