Inventory Management - EBS (MOSC)

MOSC Banner

INV_SYNC_PRINT_REQUEST creating multiple lables for GTIN cross reference items.

edited March 2018 in Inventory Management - EBS (MOSC) 1 commentAnswered ✓

Hi ,

INV_SYNC_PRINT_REQUEST creating multiple lables for GTIN cross reference items. Due to this multiple labels are printing.

Ex: If we receive 100 items system creating 100 labels. We can't change UOM while receiving because user not know which one is GTIN cross referenced item.

could you please suggest how we can modify the code.

NTO l_xml

           FROM DUAL;*/

            BEGIN

               SELECT COUNT (*)

                 INTO l_gtin_enabled_count

                 FROM apps.mtl_cross_references mcr,

                      apps.mtl_system_items_b msi,

                      apps.mtl_parameters mp

                WHERE     1 = 1

                      AND mp.organization_code = l_organization

                      AND msi.organization_id = mp.organization_id

                      AND mcr.inventory_item_id = msi.inventory_item_id

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center