APPS.JMF_SHIKYU_UTIL dependencies on MTL_SYSTEM_ITEMS

Line 100: FROM mtl_system_items

96: END IF;
97:
98: SELECT primary_unit_of_measure
99: INTO l_uom
100: FROM mtl_system_items
101: WHERE inventory_item_id = p_inventory_item_id
102: AND organization_id = p_organization_id;
103:
104: IF g_fnd_debug = 'Y' AND

Line 227: FROM mtl_system_items

223: END IF;
224:
225: SELECT primary_uom_code
226: INTO l_uom_code
227: FROM mtl_system_items
228: WHERE inventory_item_id = p_inventory_item_id
229: AND organization_id = p_organization_id;
230:
231: IF g_fnd_debug = 'Y' AND

Line 503: , mtl_system_items msi

499:
500: SELECT mum.uom_code
501: INTO l_to_code
502: FROM mtl_units_of_measure mum
503: , mtl_system_items msi
504: WHERE mum.unit_of_measure = msi.primary_unit_of_measure
505: AND msi.inventory_item_id = p_inventory_item_id
506: AND msi.primary_unit_of_measure = mum.unit_of_measure
507: AND msi.organization_id = p_inventory_org_id;

Line 770: FROM MTL_SYSTEM_ITEMS_B

766: SELECT outsourced_assembly,
767: subcontracting_component
768: INTO x_outsourced_assembly,
769: x_subcontracting_component
770: FROM MTL_SYSTEM_ITEMS_B
771: WHERE organization_id = p_organization_id
772: AND inventory_item_id = p_item_id;
773:
774: EXCEPTION