View: INVFV_MFG_PART_NUMBERS

Product:	INV - Inventory
Description:
Implementation/DBA Data:	APPS.INVFV_MFG_PART_NUMBERS

View Text

SELECT MF.MFG_PART_NUM
, MA.MANUFACTURER_NAME
, AL.NAME
, PA.ORGANIZATION_CODE
, '_KF:INV:MSTK:SY'
, '_DF:INV:MTL_MFG_PART_NUMBERS:MF'
, 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

Columns