1929:
1930: -------Checking if the item is dual UOM controlled. If not then Return .
1931: SELECT tracking_quantity_ind , secondary_default_ind
1932: INTO l_TRACKING_QUANTITY_IND ,l_secondary_default_ind
1933: FROM mtl_system_items_b
1934: WHERE INVENTORY_ITEM_ID = x_att_rec.inventory_item_id
1935: AND ORGANIZATION_ID = x_att_rec.to_organization_id;
1936:
1937: l_progress :='0004';
2016: BEGIN
2017:
2018: SELECT SECONDARY_UOM_CODE
2019: INTO l_secondary_uom_code
2020: FROM MTL_SYSTEM_ITEMS_B
2021: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID = x_att_rec.inventory_item_id
2022: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID = x_att_rec.to_organization_id;
2023:
2024: IF g_asn_debug = 'Y' THEN
2017:
2018: SELECT SECONDARY_UOM_CODE
2019: INTO l_secondary_uom_code
2020: FROM MTL_SYSTEM_ITEMS_B
2021: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID = x_att_rec.inventory_item_id
2022: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID = x_att_rec.to_organization_id;
2023:
2024: IF g_asn_debug = 'Y' THEN
2025: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );
2018: SELECT SECONDARY_UOM_CODE
2019: INTO l_secondary_uom_code
2020: FROM MTL_SYSTEM_ITEMS_B
2021: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID = x_att_rec.inventory_item_id
2022: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID = x_att_rec.to_organization_id;
2023:
2024: IF g_asn_debug = 'Y' THEN
2025: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );
2026: END IF;
2073: BEGIN
2074:
2075: SELECT SECONDARY_UOM_CODE
2076: INTO x_att_rec.secondary_uom_code
2077: FROM MTL_SYSTEM_ITEMS_B
2078: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
2079: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
2080:
2081: IF g_asn_debug = 'Y' THEN
2074:
2075: SELECT SECONDARY_UOM_CODE
2076: INTO x_att_rec.secondary_uom_code
2077: FROM MTL_SYSTEM_ITEMS_B
2078: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
2079: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
2080:
2081: IF g_asn_debug = 'Y' THEN
2082: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code ||':'||l_progress);
2075: SELECT SECONDARY_UOM_CODE
2076: INTO x_att_rec.secondary_uom_code
2077: FROM MTL_SYSTEM_ITEMS_B
2078: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
2079: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
2080:
2081: IF g_asn_debug = 'Y' THEN
2082: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code ||':'||l_progress);
2083: END IF;
2131: BEGIN
2132:
2133: SELECT SECONDARY_UOM_CODE
2134: INTO x_att_rec.secondary_uom_code
2135: FROM MTL_SYSTEM_ITEMS_B
2136: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
2137: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
2138:
2139: IF g_asn_debug = 'Y' THEN
2132:
2133: SELECT SECONDARY_UOM_CODE
2134: INTO x_att_rec.secondary_uom_code
2135: FROM MTL_SYSTEM_ITEMS_B
2136: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
2137: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
2138:
2139: IF g_asn_debug = 'Y' THEN
2140: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code||':'||l_progress );
2133: SELECT SECONDARY_UOM_CODE
2134: INTO x_att_rec.secondary_uom_code
2135: FROM MTL_SYSTEM_ITEMS_B
2136: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
2137: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
2138:
2139: IF g_asn_debug = 'Y' THEN
2140: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||x_att_rec.secondary_uom_code||':'||l_progress );
2141: END IF;
2169: BEGIN
2170:
2171: SELECT SECONDARY_UOM_CODE
2172: INTO l_secondary_uom_code
2173: FROM MTL_SYSTEM_ITEMS_B
2174: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
2175: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
2176:
2177: IF g_asn_debug = 'Y' THEN
2170:
2171: SELECT SECONDARY_UOM_CODE
2172: INTO l_secondary_uom_code
2173: FROM MTL_SYSTEM_ITEMS_B
2174: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
2175: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
2176:
2177: IF g_asn_debug = 'Y' THEN
2178: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );
2171: SELECT SECONDARY_UOM_CODE
2172: INTO l_secondary_uom_code
2173: FROM MTL_SYSTEM_ITEMS_B
2174: WHERE MTL_SYSTEM_ITEMS_B.INVENTORY_ITEM_ID=x_att_rec.inventory_item_id
2175: AND MTL_SYSTEM_ITEMS_B.ORGANIZATION_ID=x_att_rec.to_organization_id;
2176:
2177: IF g_asn_debug = 'Y' THEN
2178: asn_debug.put_line('Secondary uom code derived in VALIDATE_SECONDARY_PARAMETERS is ' ||l_secondary_uom_code||':'||l_progress );
2179: END IF;