DBA Data[Home] [Help]

APPS.INVPUTLI dependencies on MTL_SYSTEM_ITEMS_B

Line 2015: , mtl_system_items_b M

2011: , NVL(I.STYLE_ITEM_FLAG ,M.STYLE_ITEM_FLAG )
2012: , NVL(I.STYLE_ITEM_ID ,M.STYLE_ITEM_ID )
2013: FROM
2014: mtl_system_items_tl MT
2015: , mtl_system_items_b M
2016: WHERE
2017: M.inventory_item_id = item_id
2018: AND M.organization_id = master_org_id
2019: AND MT.INVENTORY_ITEM_ID = M.INVENTORY_ITEM_ID

Line 2168: FROM mtl_system_items_b

2164: IF ( l_Primary_Unit_of_Measure IS NULL ) THEN
2165: IF (l_style_item_flag = 'N' ) THEN
2166: SELECT primary_unit_of_measure
2167: INTO l_Primary_Unit_Of_Measure
2168: FROM mtl_system_items_b
2169: WHERE inventory_item_id = l_style_item_id
2170: AND organization_id = l_org_id;
2171: ELSE
2172: l_Primary_Unit_of_Measure := uom_default;