APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_MFG_PRODUCTS_V

Line 1718: from mtl_mfg_products_v

1714: , subinventory_code
1715: , locator_id
1716: , grade_code
1717: , serial_number
1718: from mtl_mfg_products_v
1719: where comp_item_id = p_product_rec.inventory_item_id
1720: and organization_id = p_product_rec.current_org_id
1721: and DECODE(comp_lot_number,NULL, '%%$#', comp_lot_number)
1722: = DECODE( p_product_rec.comp_lot_number, NULL, '%%$#', p_product_rec.comp_lot_number) --bug#14027562

Line 1748: /*Bug#5436402 The selection from view mtl_mfg_products_v fetches secondary uom irrespeive of tracking id.

1744: , p_product_rec.serial
1745: ;
1746: Exit when get_products %NOTFOUND;
1747:
1748: /*Bug#5436402 The selection from view mtl_mfg_products_v fetches secondary uom irrespeive of tracking id.
1749: if the item is not tracked in Primary and Secondary then we should not display sec qty and sec uom*/
1750: IF g_tracking_quantity_ind <> 'PS' THEN
1751: p_product_rec.secondary_quantity := NULL;
1752: p_product_rec.secondary_uom := NULL;