DBA Data[Home] [Help]

APPS.INV_ITEM_ORG_ASSIGN_CP dependencies on MTL_SYSTEM_ITEMS_B

Line 599: ' FROM mtl_system_items_b msi' ||

595: );
596: END IF;
597:
598: x_item_cursor := 'SELECT msi.inventory_item_id' ||
599: ' FROM mtl_system_items_b msi' ||
600: l_mcat_f ||
601: ' WHERE msi.organization_id = :b_master_org_id ' ||
602: l_mstk_w ||
603: l_mcat_w1 ||

Line 1347: mtl_system_items_b msib

1343: SELECT
1344: msib.primary_uom_code primary_uom_code
1345: , msib.primary_unit_of_measure primary_unit_of_measure
1346: FROM
1347: mtl_system_items_b msib
1348: , mtl_units_of_measure muom
1349: WHERE msib.organization_id = c_master_org_id
1350: AND msib.inventory_item_id = c_inventory_item_id
1351: AND msib.primary_unit_of_measure = muom.unit_of_measure