DBA Data[Home] [Help]

APPS.INVPUTLI dependencies on MTL_SYSTEM_ITEMS_B

Line 1940: , mtl_system_items_b M

1936: , NVL(I.STYLE_ITEM_FLAG ,M.STYLE_ITEM_FLAG )
1937: , NVL(I.STYLE_ITEM_ID ,M.STYLE_ITEM_ID )
1938: FROM
1939: mtl_system_items_tl MT
1940: , mtl_system_items_b M
1941: WHERE
1942: M.inventory_item_id = item_id
1943: AND M.organization_id = master_org_id
1944: AND MT.INVENTORY_ITEM_ID = M.INVENTORY_ITEM_ID

Line 2093: FROM mtl_system_items_b

2089: IF ( l_Primary_Unit_of_Measure IS NULL ) THEN
2090: IF (l_style_item_flag = 'N' ) THEN
2091: SELECT primary_unit_of_measure
2092: INTO l_Primary_Unit_Of_Measure
2093: FROM mtl_system_items_b
2094: WHERE inventory_item_id = l_style_item_id
2095: AND organization_id = l_org_id;
2096: ELSE
2097: l_Primary_Unit_of_Measure := uom_default;