SELECT assignment_group_name, g.ORGANIZATION_ID, g.ASSIGNMENT_GROUP_ID FROM MRP_PARAMETERS P,MTL_ABC_ASSIGNMENT_GROUPS G where g.ORGANIZATION_ID = p.ORGANIZATION_ID and ASSIGNMENT_GROUP_ID = DEFAULT_ABC_ASSIGNMENT_GROUP
View Text - HTML Formatted
SELECT ASSIGNMENT_GROUP_NAME , G.ORGANIZATION_ID , G.ASSIGNMENT_GROUP_ID FROM MRP_PARAMETERS P , MTL_ABC_ASSIGNMENT_GROUPS G WHERE G.ORGANIZATION_ID = P.ORGANIZATION_ID AND ASSIGNMENT_GROUP_ID = DEFAULT_ABC_ASSIGNMENT_GROUP