APPS.OZF_QP_QUAL_PVT dependencies on MTL_SYSTEM_ITEMS

Line 1944: FROM mtl_system_items

1940: WHERE org_id=p_org_id;
1941:
1942: CURSOR c_primary_uom_csr(p_inventory_item_id NUMBER, p_inv_org_id NUMBER)IS
1943: SELECT primary_uom_code
1944: FROM mtl_system_items
1945: WHERE inventory_item_id = p_inventory_item_id
1946: AND organization_id = p_inv_org_id;
1947:
1948:

Line 2263: FROM oe_order_lines_all line, mtl_system_items item

2259: WHERE line_id = p_order_line_id;
2260:
2261: CURSOR c_item_vendor(p_order_line_id IN NUMBER) IS
2262: SELECT line.attribute4
2263: FROM oe_order_lines_all line, mtl_system_items item
2264: WHERE line.line_id = p_order_line_id
2265: AND line.inventory_item_id = item.inventory_item_id;
2266:
2267: l_qualified_flag VARCHAR2(1) := 'Y';