APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_MFG_COMPONENTS_V

Line 1798: from mtl_mfg_components_v

1794: , locator_id
1795: , grade_code
1796: , serial_number
1797: , wip_entity_name
1798: from mtl_mfg_components_v
1799: where product_item_id = p_component_rec.inventory_item_id
1800: AND DECODE(product_lot_number,NULL, '%%$#', product_lot_number)
1801: = DECODE( p_component_rec.product_lot_number, NULL, '%%$#', p_component_rec.product_lot_number)
1802: AND DECODE(product_serial_number, NULL, '%%##', product_serial_number)

Line 1827: /*Bug#5436402 The selection from view mtl_mfg_components_v fetches secondary uom irrespeive of tracking ind.

1823: , p_component_rec.wip_entity_name
1824: ;
1825: Exit when get_components %NOTFOUND;
1826:
1827: /*Bug#5436402 The selection from view mtl_mfg_components_v fetches secondary uom irrespeive of tracking ind.
1828: if the item is not tracked in Primary and Secondary then we should not display sec qty and sec uom*/
1829: IF g_tracking_quantity_ind <> 'PS' THEN
1830: p_component_rec.secondary_quantity := NULL;
1831: p_component_rec.secondary_uom := NULL;