APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_MFG_COMPONENTS_V

Line 1790: from mtl_mfg_components_v

1786: , locator_id
1787: , grade_code
1788: , serial_number
1789: , wip_entity_name
1790: from mtl_mfg_components_v
1791: where product_item_id = p_component_rec.inventory_item_id
1792: AND DECODE(product_lot_number,NULL, '%%$#', product_lot_number)
1793: = DECODE( p_component_rec.product_lot_number, NULL, '%%$#', p_component_rec.product_lot_number)
1794: AND DECODE(product_serial_number, NULL, '%%##', product_serial_number)

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

1815: , p_component_rec.wip_entity_name
1816: ;
1817: Exit when get_components %NOTFOUND;
1818:
1819: /*Bug#5436402 The selection from view mtl_mfg_components_v fetches secondary uom irrespeive of tracking ind.
1820: if the item is not tracked in Primary and Secondary then we should not display sec qty and sec uom*/
1821: IF g_tracking_quantity_ind <> 'PS' THEN
1822: p_component_rec.secondary_quantity := NULL;
1823: p_component_rec.secondary_uom := NULL;