VIEW: APPS.INVFV_ABC_ASSIGNMENTS

Source

View Text - Preformatted

SELECT MAA.ASSIGNMENT_GROUP_ID , MAG.ASSIGNMENT_GROUP_NAME , MAA.ABC_CLASS_ID , MAC.ABC_CLASS_NAME , MAA.INVENTORY_ITEM_ID ,'_KF:INV:MSTK:MSI' /* KEYFLEX */ , MAG.ORGANIZATION_ID , MP.ORGANIZATION_CODE , HOU.NAME , MAA.CREATED_BY , MAA.CREATION_DATE , MAA.LAST_UPDATED_BY , MAA.LAST_UPDATE_DATE FROM MTL_PARAMETERS MP, HR_ALL_ORGANIZATION_UNITS HOU, MTL_SYSTEM_ITEMS MSI, MTL_ABC_CLASSES MAC, MTL_ABC_ASSIGNMENT_GROUPS MAG, MTL_ABC_ASSIGNMENTS MAA WHERE MAG.ASSIGNMENT_GROUP_ID = MAA.ASSIGNMENT_GROUP_ID AND MAC.ABC_CLASS_ID = MAA.ABC_CLASS_ID AND MSI.ORGANIZATION_ID = MAG.ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = MAA.INVENTORY_ITEM_ID AND MP.ORGANIZATION_ID = MAG.ORGANIZATION_ID AND HOU.ORGANIZATION_ID = MAG.ORGANIZATION_ID AND '_SEC:MAG.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT MAA.ASSIGNMENT_GROUP_ID
, MAG.ASSIGNMENT_GROUP_NAME
, MAA.ABC_CLASS_ID
, MAC.ABC_CLASS_NAME
, MAA.INVENTORY_ITEM_ID
, '_KF:INV:MSTK:MSI' /* KEYFLEX */
, MAG.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HOU.NAME
, MAA.CREATED_BY
, MAA.CREATION_DATE
, MAA.LAST_UPDATED_BY
, MAA.LAST_UPDATE_DATE
FROM MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS HOU
, MTL_SYSTEM_ITEMS MSI
, MTL_ABC_CLASSES MAC
, MTL_ABC_ASSIGNMENT_GROUPS MAG
, MTL_ABC_ASSIGNMENTS MAA
WHERE MAG.ASSIGNMENT_GROUP_ID = MAA.ASSIGNMENT_GROUP_ID
AND MAC.ABC_CLASS_ID = MAA.ABC_CLASS_ID
AND MSI.ORGANIZATION_ID = MAG.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = MAA.INVENTORY_ITEM_ID
AND MP.ORGANIZATION_ID = MAG.ORGANIZATION_ID
AND HOU.ORGANIZATION_ID = MAG.ORGANIZATION_ID
AND '_SEC:MAG.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY