INV Item ABC Assignment Upload Copy link
Description
- Categories
- Enginatics, Upload
- Repository
- GitHub
Assigns items to ABC classes within an ABC assignment group, changes an item's ABC class, or removes the assignment, as the ABC Assignment Updates window (Inventory > Planning > ABC Codes > ABC Assignments).
The ABC group and its classes are set up in the ABC Groups window; an item can be assigned to any class of the group, also when the ABC compile did not include it.
The ABC group and its classes are set up in the ABC Groups window; an item can be assigned to any class of the group, also when the ABC compile did not include it.
SQL 27 lines
select null action_, null status_, null message_, null modified_columns_, mp.organization_code, maag.assignment_group_name abc_group, msiv.concatenated_segments item, msiv.description item_description, mac.abc_class_name abc_class, mac.description abc_class_description, null delete_assignment, to_number(null) upload_row from mtl_parameters mp, mtl_abc_assignment_groups maag, mtl_abc_assignments maa, mtl_abc_classes mac, mtl_system_items_vl msiv where 1=1 and mp.organization_id in (select oav.organization_id from org_access_view oav where oav.resp_application_id=fnd_global.resp_appl_id and oav.responsibility_id=fnd_global.resp_id) and mp.organization_id=maag.organization_id and maag.assignment_group_id=maa.assignment_group_id and maa.abc_class_id=mac.abc_class_id and maa.inventory_item_id=msiv.inventory_item_id and maag.organization_id=msiv.organization_id |
Parameters 5
| Parameter | Type | List of values SQL | |
|---|---|---|---|
| Upload Mode | LOV |
| |
| Organization Code | LOV |
| |
| ABC Group | LOV |
| |
| ABC Class | LOV |
| |
| Item | LOV |
|