DBA Data[Home] [Help]

APPS.INV_GENEALOGY_REPORT_GEN dependencies on MTL_MFG_PRODUCTS_V

Line 1714: from mtl_mfg_products_v

1710: , subinventory_code
1711: , locator_id
1712: , grade_code
1713: , serial_number
1714: from mtl_mfg_products_v
1715: where comp_item_id = p_product_rec.inventory_item_id
1716: and organization_id = p_product_rec.current_org_id
1717: ;
1718: Begin

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

1736: , p_product_rec.serial
1737: ;
1738: Exit when get_products %NOTFOUND;
1739:
1740: /*Bug#5436402 The selection from view mtl_mfg_products_v fetches secondary uom irrespeive of tracking id.
1741: if the item is not tracked in Primary and Secondary then we should not display sec qty and sec uom*/
1742: IF g_tracking_quantity_ind <> 'PS' THEN
1743: p_product_rec.secondary_quantity := NULL;
1744: p_product_rec.secondary_uom := NULL;