INV_SYNC_PRINT_REQUEST creating multiple lables for GTIN cross reference items.
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