FND Design Data [Home] [Help]

View: MRP_DEFAULT_ABC_ASSIGN_VIEW

Product: MRP - Master Scheduling/MRP
Description: Default ABC Assignment Groups
Implementation/DBA Data: ViewAPPS.MRP_DEFAULT_ABC_ASSIGN_VIEW
View Text

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

Columns

Name
ASSIGNMENT_GROUP_NAME
ORGANIZATION_ID
ASSIGNMENT_GROUP_ID